My output:

select OrderID, price from ORDER_ITEM where price > (select avg(price) from ORDER_ITEM) order by price desc

OrderID price ----------- --------------------------------------- 2001 175.50 1035 145.00 3022 145.00 2002 125.00 1033 100.00 1032 85.00 1031 82.50 1019 80.00 1038 57.50 1016 47.95 1018 47.50 3021 35.00 1004 32.50 1020 30.00

(14 rows affected)

Now I need to get another column, from a different linking table.

How would I add another subquery for this?