Selecting using 2 tables

[camvoss]

Hi guys,

I'm looking for a little assistance on how to select rows from a database where the 'where' clause sort of takes in affect 2 tables. Sorry, I find it hard to explain!!

Here's the basic structure of the 2 tables I'm using for this particular statement:

VENUES: id, venue_name, city
EVENTS: id, event_name, venue_id

What I need to do is select all events from the events table where the city of the venue equals a particular city, eg 'melbourne'. The venue_id of the events equals the the id in the venues table. Any help would be greatly appreciated.

Kind Regards,
Cam
😕

[xblue]

a simple join should do, I think

SELECT e.id,
...
FROM events e, venues v
WHERE e.venue_id=v.id
AND v.city='melbourne'

[camvoss]

Thanks xblue, that worked a treat. Learn something new every day!!

Thanks for your help,
Cam 😉