|
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)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.