Joined: 24 May 2007
I have PLI-DB2 program in which the following data needs to be extracted.
fields: id and data
fields: account and data
I need to read accounts one by one and match the data with table 1 to find the id(s) for the account.
In my example case,
for a1, 3 should be returned
for a2, none
for a3, 1,2 & 3 should be returned. 2 & 3 because, the account has the required data.
I tried the following query.. but it couldn't get me the ids 2 & 3 for account a3.
|SELECT id FROM TABLE1 AS A TABLE2 AS B
WHERE '%A.DATA%' LIKE 'B.DATA' WHERE B.ACCOUNT = 'A3'