select statements from multiple tables

[dbdummy]

I haven't created a select statement in almost a year...so consider me a noobie again.

I have three tables, one with course information, one with city information and one with date information. I am a bit baffled about how to create the select statement...

my databases are as the following

-cities-
pkey - primary key
cityname
citysite

-courses-
ckey - primary key
coursenumber
coursename
coursedescription

-prodates-
date_id - primary key
promonth
proday
proyear
procity - foreign key of cities table - cityname
procourse - foreign key of course table - coursenumber

what I need is to select from a.prodates where a.promonth = 'july' and a.proyear = '2006 and then I need to it to know to select from b.courses where a.procourse = b.coursenumber and a.procity = c.cityname

after that I need to have it put it all together...but I can't seem to figure out how to best create the first select statement

Is there some good tutorial that will help explain this?

thanks
Barbara

[minestrone]

im no expert but this might work..

SELECT a.* FROM #prodates AS a
LEFT JOIN #courses AS b ON a.procourse = b.ckey
LEFT JOIN #city AS c ON a.procity = c.pkey
WHERE a.promonth = 'july' and a.proyear = '2006

SELECT b.* FROM #prodates AS a
LEFT JOIN #courses AS b ON a.procourse = b.ckey
LEFT JOIN #city AS c ON a.procity = c.pkey
WHERE where a.procourse = b.coursenumber and a.procity = c.cityname

well maybe.. :-)

[bogu]

SELECT * FROM prodates p
LEFT JOIN cities c ON p.procity = c.cityname
LEFT JOIN courses c1 ON p.procourse = c1.coursenumber
WHERE p.promonth = 'july' AND p.proyear = '2006'

This is from your specification ...