[thelist] How do I properly query multiple tables?

[Pringle, Ron]

Brian and Mark-

Thank you for the help! I wasn't making the right connections in my brain
about the JOIN statements. Now it makes sense. I'll give it a try.

Thanks!

Ron



> ok, so the first thing you want to do is grab the date from the 
> querystring and make it a local var to make things easier to read
> 
> EDate = CDate(Request.QueryString("EventDate"))

> select * from tbl_event EV	
> join tbl_eventdates ED
> on EV.eventID = ED.eventID
> -->//// now do the same join for the other tables...
> join tbl_contact C
> on EV.eventID = C.eventID
> join tbl_link L
> on EV.eventID = L.eventID
> where EV.eventdate = EDate