The documentation for what you are trying to do is at:

http://docs.hp.com/mpeix/all/#MPE/iX%20Databases

ALLBASE/SQL Reference Manual has several examples.

Here is a working example that does several outer joins.

Select * from smt.systems
 LEFT JOIN smt.systems2 USING (system_name_long)
 LEFT JOIN smt.contacts USING (system_name_long)
 LEFT JOIN smt.asset_info USING (system_name_long)
 LEFT JOIN smt.drp_info USING (system_name_long)
 WHERE platform = 'MPE'
 ORDER BY managing_site, system_name_short;e

HTH
-----Original Message-----
From: Edwin B. Aldrin [mailto:[log in to unmask]]
Sent: Wednesday, March 06, 2002 14:48
To: [log in to unmask]
Subject: SQL/ALLBASE question


Calling all SQL experts ...

I have 2 detail datasets containing Purch Order Header and Comment lines.
The Header key is POH.PO (P12 -packed format) while the key to the Comments
dset is POC.key (X12 - "PO" + to_char(PO,"000000") + "0001").

Does anybody know the SQL/Allbase construct to do "outer joins" ? Of
course, comments are optional for a PO. Any help w/be appreciated...

Thanks

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *