[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Outer joints (left and right)

Does SQR supports left or right outer joints?  I could not find any note on my 
reference on line book.

 

Here is my syntax that works against a SQLserver database:

 

SELECT A.SETID, A.VENDOR_ID, A.NAME1, A.NAME2, A.VENDOR_STATUS, A.WTHD_SW, 
B.STD_ID_NUM

FROM  PS_VENDOR A LEFT OUTER JOIN PS_VENDOR_ID_NBRS B

           ON A.SETID =  B.SETID

           AND A.VENDOR_ID = B.VENDOR_ID

 

Thanks,

 

José A. Aguirre

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users