Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-13 : 08:06:11
|
| Ryan writes "How can I get the lowest price for the same product in 2 tables, Great Buy and Contract List?GreatBuyProdCode Price1 $5.00ContListProdCode Price1 $2.00The query that I required will return price of $2.00. Hope to get a reply from u soon. Thks." |
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2002-06-13 : 08:27:17
|
| select prodcode,min(price) minpricefrom (select prodcode,pricefrom greatbuyunionselect prodcode,pricefrom contlist) allpricesgroup by prodcodemacka. |
 |
|
|
theerut
Starting Member
1 Post |
Posted - 2011-04-20 : 09:27:29
|
| unspammed |
|
|
|
|
|
|
Compare Prices