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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.