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.
Greetings folks,
This is a follow up to my initial message some time ago. Now I have
got all the details together.
I have two tables.
Table A - Which contains one row per entry
Table B - Which contains multiple rows per entry
Table B relates to Table A by a field say called ID. Table A in this
Hi,
I am looking for a way to sort data returned from two tables with the
first sort based on a field from table A and the secord sort based on
the results of the first sort but the sort field is from table B.
While I can sort on either fields from either table, I cannot get it
to work on both. I
