|
I'm trying to pseudocode an SQL solution for my current project. I'm
stumped at trying to use the "USING" reserved word in the section that uses
"LEFT OUTER JOIN". Did I use it correctly?
Thanks,
Frank
=================================================
FILE1 is the header file, keyed on F1KEY1 and F1KEY2.
FILE2 is the detail file, keyed on F2KEY1 and F2KEY2.
Here's an example of what my SQL pseudocode code looks:
CREATE VIEW ROB/DOUGGIE
(F1KEY1, F1KEY2, F2DETAIL)
AS SELECT
FILE1.F1KEY1, FILE1.F1KEY2,
FILE2.F2DETAIL
FROM
(FILE1
LEFT OUTER JOIN FILE2 USING (F1KEY1 AND F1KEY2)
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.