x27;
") 23:59:59' as datetime)
Did the above, got the expected results, did not
specify 'Outer Join' only specified Join, is that a problem?
From: Muralidharan Ramakrishnan
[mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005
10:41 PMTo: Wadhwa, Amit; pgsql-sql@postgr
SELECT A.SID , A.RECDATE , B.MID , B.MBDATE , C.ISSDATE FROM TableA A LEFT OUTER JOIN TableB B ON A.SID = B.SIDLEFT OUTER JOIN TableC C ON B.MID = C.MIDORDER BY A.SID[EMAIL PROTECTED] wrote:
All,
Using Postgres 8.0 on Windows Server 2003 - 16GB Ram, 3Ghz X 2 Xeons
Accessing through JDBC / J
Thanks a lot, that worked for me!
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 27, 2005 2:47 PM
To: Wadhwa, Amit
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Complex Query - Data from 3 tables simultaneously
[EMAIL PROTECTED] wrote
[EMAIL PROTECTED] wrote:
Basically I want a raw dump of data
- Should have all the shipments regardless of whether they have any
material items entered or not
- Should have all Material Items for Every Shipment regardless of
whether it was issued or not.
I know I need an outer join (Do I Not?
All,
Using Postgres 8.0 on Windows Server 2003 - 16GB Ram,
3Ghz X 2 Xeons
Accessing through JDBC / JSP
I have 3 shipment tables.
Table A - Records arrived
Shipments.
Table B - Records Materials (maybe more than one per
shipment) in the shipment.
Table C - Records Issuances of material (
