SQL query to get multiple records
I have an SQL table as below (columns - ID and Value)
I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID
as -
if ID = 11 ; QRY output = aaa,bbb
if ID = 22 ; QRY output = xxx,yyy,zzz
can someone help me with query
ID Value
----------
11 aaa
22 xxx
22 yyy
11 bbb
22 zzz
-----------
Discussion (0)0
Comments
ÍD is an reserved name in IRIS / Ensemble
in fact as you describe it, it is rather a KEY than a typical ID
so this query may serve your needs
SELECT LIST(Value) WHERE KEY=11
SELECT LIST(Value) WHERE KEY=12
Thank you.