By viewsI 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
-----------