Help/Systems SEQUEL Software PowerTech
Home › Forums › Data Access and Analysis › SEQUEL

Query formation using CASE statement in SEQUEL

Submitted by varada_rm on Wed, 2010-03-10 04:43
in

Hi,

I was able to execute the below query in STRSQL using CASE statment:

SELECT A.PARTY,A.OFFICE,A.CREATE_DT,A.INVTR_TYPE,
CASE WHEN C.PARTYTYPE = 'CORPORATE' THEN (SELECT BUSINESS FROM
RSITBASOBJ/PACORP WHERE PARTY = A.PARTY) END AS BUSINESS
FROM RSITBASOBJ/PARTYM AS A,RSITBASOBJ/PAPORTFO AS B,
RSITBASOBJ/PAPARTTY AS C
WHERE A.PARTY = B.PARTY AND A.PARTYTYPE = C.PARTYTYPE

Kindly guide me how to build the same query in SEQUEL.

Thanks,
Kp

‹ Max Form Width for reporting Joining multiple tables in Sequel ›

Translate your SQL syntax

Submitted by richg on Wed, 2010-03-17 16:12.

Kindly give Help/Systems Sequel support a call at 952-933-0609 and one of the available consultants would be able to step you through the view creation process.

Login to post new content in forum or to comment on an existing forum post.

Need Help?

Talk to Us
In the U.S. and Canada, call 1-800-328-1000 and ask for Sales.
Elsewhere in the world, contact your local international office.