Sort one query result by another table's field?

[Edgewalker81]

I have two tables in this project I'm working on, and one looks like this:

 

schools

---------

school_id

school_name

address1... etc. etc.

 

events

---------

school_id

event_type

start_time... etc. etc.

 

What I want to do is retrieve a list of all events ("SELECT * FROM events WHERE ...") but sort that result set by the school_name.  I'm sure SQL allows this... I keep trying to "JOIN" somehow, but I haven't gotten it right yet.

 

Any help appreciated, thank you in advance.

[aschk]

Try

 

SELECT s.school_name, e.* 
FROM events e
JOIN schools s ON e.school_id = s.school_id
WHERE ... <BLAH BLAH BLAH>
ORDER BY s.school_name ASC

 

Let me know if that's what you were expecting.

[Edgewalker81]

Yes, thank you, and I also now have a much better general understanding of how to use JOIN.