SQL Query with join help needed

[jnmunsey]

I have one table with fields:
performerid
performername
eventid

another table with fields:
eventid
eventname

I want to make a query that lists all eventnames for a given performerid

Any help is appreciated

[jnmunsey]

Never mind I figured it out on the first try...

SELECT Events.* FROM EventPerformers LEFT JOIN Events ON EventPerformers.EventID=Events.EventID WHERE EventPerformers.EventID = Events.EventID AND EventPerformers.PerformerID = 61

61 is a performerid

if there is a better way please let me know.

oh and this is for mysql

[Terrorke]

This one is just fine ;)

[jnmunsey]

Thanks, Chief!