Обсуждение: Sorting data based fields in two linked tables

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 have tried a crosstab query, but this a fails as
the number of rows returned from TABLE B for each row in TABLE A is an
unknown. I tried creating a temporary table, to then sort on, but this
failed as well. Example layout below:

Table A

ID FIELD1 FIELD2

Table B

ID, A.ID FIELD1,FIELD2

Output Based on sorting A.FIELD2, then B.FIELD1

A.ID,A.FIELD1,A.FIELD2,  B.FIELD1,B.FIELD2, B.FIELD1,B.FIELD2, B.FIELD1,B.FIELD2

Can anyone help me with this?

Regards

Can you provide An example?

Best,
Oliveiros

Enviado via iPhone

Em 13/05/2011, às 04:00 PM, "R. Smith" <ship.quotes@gmail.com> escreveu:

> 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 have tried a crosstab query, but this a fails as
> the number of rows returned from TABLE B for each row in TABLE A is an
> unknown. I tried creating a temporary table, to then sort on, but this
> failed as well. Example layout below:
>
> Table A
>
> ID FIELD1 FIELD2
>
> Table B
>
> ID, A.ID FIELD1,FIELD2
>
> Output Based on sorting A.FIELD2, then B.FIELD1
>
> A.ID,A.FIELD1,A.FIELD2,  B.FIELD1,B.FIELD2, B.FIELD1,B.FIELD2, B.FIELD1,B.FIELD2
>
> Can anyone help me with this?
>
> Regards
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql