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=u9SPiCinoBCaoE9sVsMw0mDATFzEMvkT1Vxvi8rwifsJz91r9tHXxKH8Qn5XmWnt9SGqw+UJ5yPgDarLYwsZ4w2qzcLrg000iqrvBhSUfUvcUj/w3K9MeY7mwSGCKaGIBNQziIjmP0E/ZAPwtVmVhTE7QJBm3YTF8TlWmqoGGd8=
	;
References: 
 <CADuTMYBbypDgCT6nnFoJwT2JuHdKAiAYhR2inAWf6LkY7xMi3Q@mail.gmail.com>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: 
 <CADuTMYBbypDgCT6nnFoJwT2JuHdKAiAYhR2inAWf6LkY7xMi3Q@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-3-805674614
Content-Transfer-Encoding: 7bit
Message-Id: <27CF61B6-2101-4FD7-91BD-DC82C59E9015@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: Sat, 17 Sep 2011 09:56:46 -0400
To: "R. Smith" <ship.quotes@gmail.com>


--Apple-Mail-3-805674614
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

On Sep 17, 2011, at 9:32, "R. Smith" <ship.quotes@gmail.com> wrote:

>=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

It would help if you gave an example comparing the above query results with y=
our desired results.  It would also help if you actually provided a detailed=
 description of you goal instead of the generic one quoted above.  Given you=
r stated need the query does exactly what you requested.

David J.=

--Apple-Mail-3-805674614
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><body bgcolor=3D"#FFFFFF"><div>On Sep 17, 2011, at 9:32, "R. Smith" &l=
t;<a href=3D"mailto:ship.quotes@gmail.com">ship.quotes@gmail.com</a>&gt; wro=
te:<br><font class=3D"Apple-style-span" color=3D"#0023A3"><font class=3D"App=
le-style-span" color=3D"#000000"><br></font></font></div><blockquote type=3D=
"cite"><div><span></span><br><span>What I want to do is do a query joining t=
able A with B and sorting</span><br><span>firstly on a field in Table A then=
 on several fields in Table B.</span><br><br><span></span><br><span>SELECT a=
.gdn_gdn, a.gdn_custref, a.gdn_date, a.gdn_address_name,</span><br><span>a.g=
dn_method, b.gdn_stockref, b.gdn_row, b.gdn_bay, b.gdn_shelf</span><br><span=
>FROM a</span><br><span>LEFT JOIN b</span><br><span>ON a.gdn_gdn =3D b.gdn_g=
dn</span><br><span>ORDER BY a.gdn_method,b.gdn_row, b.gdn_bay, b.gdn_shelf</=
span><br><span></span><font class=3D"Apple-style-span" color=3D"#000000"><fo=
nt class=3D"Apple-style-span" color=3D"#0023A3"><br></font></font></div></bl=
ockquote><br><div>It would help if you gave an example comparing the above q=
uery results with your desired results. &nbsp;It would also help if you actu=
ally provided a detailed description of you goal instead of the generic one q=
uoted above. &nbsp;Given your stated need the query does exactly what you re=
quested.</div><div><br></div><div>David J.</div></body></html>=

--Apple-Mail-3-805674614--