Two level sort
Posted: Wed Nov 16, 2011 12:13 pm
Hello;
Here is my problem: I have 2 Tables for wich there is a many 2 many link that i tought would be best is provided by a 3rd table.
In the 1st table i have SCHOOLS and in the other i have PUBLIC TRANSPORT STOPS.
any School my have more than one Transport stops associated to them and same goes with
Transport stops who may have more than one shool associated to them
thus the 3rd Table _M2M
I would like a query that would sort Schools ASC & sort ASC under each School the Public Transport Stops associated to them sorted like this:
Listing:
School A
Stop A
Stop Y
Stop Z
-----------------
School B
Stop C
Stop D
Stop Z
-----------------
etc
I looked and looked but can't find the solution that i suppose to be straightfoward :/
Thank you for your help !
Regards,
Paul
Here is my problem: I have 2 Tables for wich there is a many 2 many link that i tought would be best is provided by a 3rd table.
In the 1st table i have SCHOOLS and in the other i have PUBLIC TRANSPORT STOPS.
any School my have more than one Transport stops associated to them and same goes with
Transport stops who may have more than one shool associated to them
thus the 3rd Table _M2M
I would like a query that would sort Schools ASC & sort ASC under each School the Public Transport Stops associated to them sorted like this:
Listing:
School A
Stop A
Stop Y
Stop Z
-----------------
School B
Stop C
Stop D
Stop Z
-----------------
etc
I looked and looked but can't find the solution that i suppose to be straightfoward :/
Thank you for your help !
Regards,
Paul