Strange query...

Hi everybody!
I have a problem with something. I have an "event" table. For each event there should a few contact people, customers, and technicians. Now, I created a table for the event, which including a few details about the event, three tables, that will have everyone the details for a contact man or customer or technician (depens which table). Finally I created three more tables, that will combine a certain event (by his ID) with a few contact men, or customers etc.
Now, my question is how can I create a report that will include all the above details. It should look something like that:

event_name: "bla bla"
contact peoples: "Jon"
"Bob"
customers: "Jim"
"Alice"
etc...

I don't know how to do it...
Any ideas?
Thanks
Daniel

What are you going to be using for reporting software?

What kind of database are you using?

Hi.
I am going to use the vb report writer... or maybe the crystal report that come with vb (v. 4.6)...
My database is access 2000.
Thanks
Daniel

You would have to use 'JOIN' in your sql statements...

Thanks..But how exactly? I Don't think I understood... Can you give me an example?
Thanks
Daniel