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

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

Steve,

Would you mind  sending some sample syntax?  I looked at some articles on line 
and tried without any success.

Thanks,

José A. Aguirre

-----Original Message-----
From: sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org 
[mailto:sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org] On Behalf Of 
Jones.Steven@ups-scs.com
Sent: Friday, May 16, 2008 4:33 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Outer joints (left and right)

SQR supports left outer, right outer, and inner joins.  Just use the ansi 
standard syntax.
-Steve 

-----Original Message-----
From: sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org 
[mailto:sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org] On Behalf Of 
Aguirre, Jose
Sent: Friday, May 16, 2008 1:47 PM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: [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



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

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