Select a value from another Table containing values but not in the same row

SQLServerCentral » Latest topics

Select a value from another Table containing values but not in the same row

Hello,
I'm a T SQL newbie and need some advice.
I have two tables:
1) consumed quantity
Key    Quantity
aa       500

2) price list with different prices for kkey and consumed quantity
Key   Qu

more info...