I'm trying the below code, but it throws an error.
Here is the code:
SELECT DISTINCT LEGAL_CD,LEGAL_C
(SELECT PICKLIST_VALUE_CD LEGAL_CD,VALUE_TX LEGAL_C
WHERE PICKLIST_VALUE_CD IN ('6038','8142')
AND PICKLIST_TYPE_ID = 107
(SELECT PICKLIST_VALUE_CD COUNTY_CD,VALUE_TX LDSS
WHERE PICKLIST_TYPE_ID = 104
and here is the error.
Exception: DBD, [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "CROSS" was found following "YPE_ID = 107 ) LG". Expected tokens may include: "<space>". SQLSTATE=42601
Can someone kindly help to get it to work?