Hi Guys,

Can you plz help me out with this query.

Using a single query, I want to find out the orderIDs that have itemID 889 and then list all the itemIDs for these orderIDs.

The table orderitems is like this way

orderID itemID
101 889
101 677
102 889
102 456
103 974


Output should be:

...