Basic JOIN query?

[sroughley]

Hey all.

I'm not new to MySQL, but I am new to the JOIN queries, and, as allways, the MySQL manual is giving me a bit of a headache here. Basically all I want to do is find a row in one table using its foreign key. I have a table called 'Club' and a Table called 'Promoter'. Club's Primary Key is 'oid' and Promoter has a Foreign Key named 'myClub' (REFERNCES Club(oid)). Now how would I write the query to find a row in Club by myClub in Promoter?

Thanks for your help.

Regards.

Steve.

[iceiceboom]

Have a look here, this should help:
http://sqlcourse2.com/joins.html

[ahundiak]

SELECT * FROM club,promoter
WHERE club.oid = promoter.myClub
AND promoter.name = 'Jesse Jackson';

It's also useful to become familiar with the actual JOIN syntax.

SELECT * from club
LEFT JOIN promoter ON club.oid = promoter.myClub
WHERE promoter.name = 'Alan Sharpton';