Re: [SQL] Sorting of data from two tables

2011-09-25 Thread David Johnston
On Sep 25, 2011, at 12:37, "R. Smith" wrote: > On Sat, Sep 17, 2011 at 2:56 PM, David Johnston wrote: >> On Sep 17, 2011, at 9:32, "R. Smith" wrote: >> >> >> What I want to do is do a query joining table A with B and sorting >> firstly on a field in Table A then on several fields in Table B. >

Re: [SQL] Sorting of data from two tables

2011-09-25 Thread R. Smith
On Sat, Sep 17, 2011 at 2:56 PM, David Johnston wrote: > On Sep 17, 2011, at 9:32, "R. Smith" wrote: > > > What I want to do is do a query joining table A with B and sorting > firstly on a field in Table A then on several fields in Table B. > > > SELECT a.gdn_gdn, a.gdn_custref, a.gdn_date, a.gdn