Edgewalker81 Posted March 25, 2008 Share Posted March 25, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/97822-sort-one-query-result-by-another-tables-field/ Share on other sites More sharing options...
aschk Posted March 25, 2008 Share Posted March 25, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/97822-sort-one-query-result-by-another-tables-field/#findComment-500500 Share on other sites More sharing options...
Edgewalker81 Posted March 25, 2008 Author Share Posted March 25, 2008 Yes, thank you, and I also now have a much better general understanding of how to use JOIN. Quote Link to comment https://forums.phpfreaks.com/topic/97822-sort-one-query-result-by-another-tables-field/#findComment-500502 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.