December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.
SELECT DISTINCT LEGAL_CD,LEGAL_C ,COUNTY_CD,LDSS FROM (SELECT PICKLIST_VALUE_CD LEGAL_CD,VALUE_TX LEGAL_C FROM TB_PICKLIST_VALUES WHERE PICKLIST_VALUE_CD IN ('6038','8142') AND PICKLIST_TYPE_ID = 107 ) LG CROSS JOIN (SELECT PICKLIST_VALUE_CD COUNTY_CD,VALUE_TX LDSS FROM TB_PICKLIST_VALUES WHERE PICKLIST_TYPE_ID = 104 ) CY
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 State: 42601