SQL "USING" reserved word

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

Frank,

You wrote:

"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)"


While I'm not creating a view(just put in CREATE TABLE, would something
like the following work for you with your tables and columns substituted
where appropriate?  And, of course, substitute your LEFT OUTER JOIN
where I have EXCEPTION JOIN.   I think you need to use  the "ON" word.  
I least it works for me.

SELECT distinct(UTCSID),UTCSNM,         
UTCSA2,UTCSZP                           
 ,ASBPCD,ASANTX,ASCICD                  
  FROM "CXLIB"/"UT200AP"                
 exception JOIN "HTEGPL"/"LMASREP" on   
 utcszp  =  ASBPCD                      
 order by utcszp                        

Take care,

Dave