I want to know if there is a way to get multiple results of a subquery in one column for the query... Something like this:
otherid | resultsFromsomeData
1 | 1,2,3
2 | 1,5
3 | No Data
I was trying something like this:
select o.otherID,
CASE WHEN (select otherID from someData where someid=o.otherID)>1 THEN
''||(select otherID from someData where someid=o.otherID)||'' /*here I am*/
WHEN (select otherID from someData where someid=o.otherID)<1 THEN
'No Data'
END
as resultsFromsomeData
from OtherData o
Looks like a simple join and group by: