DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=rWSRdyqmsAuJgJVM68b6khjyg8995h6QEYRXoT/jpg87SBXNiP2XNuknFZwwo4Qhx3BihvewDeQjttjKbDMDFxElH56utEIlfcfE8cafDiPJoYkUQktssxiv5VqLh6yp59wxR7WOpTx90ImoHonadNGSILUD6q+RhRJ1T6FZ1ak=
	;
References: 
 <CADuTMYBbypDgCT6nnFoJwT2JuHdKAiAYhR2inAWf6LkY7xMi3Q@mail.gmail.com>
	<27CF61B6-2101-4FD7-91BD-DC82C59E9015@yahoo.com>
	<CADuTMYBwTaecTyZG_a0zbviPpF65PQ0zm7uyaG5oxocxVoFfDg@mail.gmail.com>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: 
 <CADuTMYBwTaecTyZG_a0zbviPpF65PQ0zm7uyaG5oxocxVoFfDg@mail.gmail.com>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <0979B205-58B1-4C58-BED6-FED40C4665A2@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: Sorting of data from two tables
Date: Sun, 25 Sep 2011 14:44:52 -0400
To: "R. Smith" <ship.quotes@gmail.com>

On Sep 25, 2011, at 12:37, "R. Smith" <ship.quotes@gmail.com> wrote:
> On Sat, Sep 17, 2011 at 2:56 PM, David Johnston <polobo@yahoo.com> wrote:
>> On Sep 17, 2011, at 9:32, "R. Smith" <ship.quotes@gmail.com> wrote:
>>=20
>>=20
>> 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.
>>=20
>>=20
>> SELECT a.gdn_gdn, a.gdn_custref, a.gdn_date, a.gdn_address_name,
>> a.gdn_method, b.gdn_stockref, b.gdn_row, b.gdn_bay, b.gdn_shelf
>> FROM a
>> LEFT JOIN b
>> ON a.gdn_gdn =3D b.gdn_gdn
>> ORDER BY a.gdn_method,b.gdn_row, b.gdn_bay, b.gdn_shelf
>>=20
>>=20
>> It would help if you gave an example comparing the above query results wi=
th
>> your desired results.  It would also help if you actually provided a
>> detailed description of you goal instead of the generic one quoted above.=

>>  Given your stated need the query does exactly what you requested.
>> David J.
>=20
> Ok, here is some more specific information. The data stored is
> inventory pick data.
> We have a table which stores all the header information, addresses etc
> (Table A) and
> then each order line (Table B) which stores item to be picked and location=
.
>=20
>=20

There isn't any useable way to output a variable number of columns.  So, you=
 need to decide how the data is going to be used and specify the order by ac=
cordingly. You can use window functions to capture some of the order informa=
tion from discontiguous lines; including ARRAY_AGG().

You should also ask yourself if you are trying to do too much with a single q=
uery/report.  If you are stuck with CSV export your non-SQL options are limi=
ted but maybe your reporting environment can assist.  If you are stuck with C=
SV you could try using array_agg and then convert the resultant array to a f=
ormatted string for output.  CSV would surround the entire formatted output i=
n quotes but maybe you could post-process the result to remove the quotes so=
 that, say Excel, would see the string as simply being additional columns in=
 the file.

David J.=