[SOLVED] Simple Join Problem

[simpsimp]

Hi - this is a simple problem, but I'm still trying to figure out joins!  Hope you can help.

 

I have a table EVENTS and a table CONCERTS - CONCERTS has a row called TYPE.

 

I just want to sort the EVENTS by the TYPE of CONCERT contained in the EVENTS.

 

Sort of like - SELECT * from events ORDER BY events.concert.type ASC

 

But I can't get this working.

 

Thanks!

[kirk112]

how do you join the events table to the concerts table?

 

If its on event_id then the following should work

 

SELECT *

FROM events AS e

LEFT JOIN concerts AS c ON e.event_id = c.event_id

ORDER BY c.type

[simpsimp]

Thanks Kirk112!

 

The following did the trick:-

 

SELECT *

FROM live_event AS e

LEFT JOIN live_concert AS c ON e.concert = c.id

ORDER BY c.type

 

This is the area of MySQL which makes my head hurt...