HP3000-L Archives

March 2002, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
SQL/ALLBASE question
From:
"Edwin B. Aldrin" <[log in to unmask]>
Reply To:
Edwin B. Aldrin
Date:
Wed, 6 Mar 2002 16:47:50 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (14 lines) 
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 *

ATOM RSS1 RSS2