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

["Gauravs Singh" <gauravs2@chetu.com>]

Hi,please help me out for returing a value into an sqr function....if code
is available than please post ......sqr 4.1   


Thanks and Regards

 Gaurav Singh

 Chetu Inc.

 Ph: +91-120-4251340 Outside US

 Ph: +1 305-704-3689 x-422 Within US

 Fax:+1 305-832-5987

  


-----Original Message-----
From: sqr-users-bounces+gauravs2=chetu.com@sqrug.org
[mailto:sqr-users-bounces+gauravs2=chetu.com@sqrug.org] On Behalf Of
Jones.Steven@ups-scs.com
Sent: Saturday, May 17, 2008 3:03 AM
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