If I got something like SELECT i1.Name FROM item it
INNER JOIN ingredient i1 ON i1.Id = it.idTest WHERE it.orderId IN (SELECT orderId FROM item) that returns all unique orderId , how can I make it to return i1.Name as an array since orderId is not unique ?