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 |
|
ricc
Starting Member
16 Posts |
 Posted - 2011-07-14 : 03:57:40
|
| Hi, I have the following two tables:******ITEMS******ItemID__PriceA_____5B_____6C_____7******MAPPING******MappingID__MasterItemID__MappedItemID1_________A_____________BI now want to write a query that returns the two lowest priced items: eg A and C (as A is mapped to B)??Any pointers would be great!ThanksRic |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-07-14 : 04:12:11
|
how is the mapping like ? will you have A mapped to B and B mapped to D and D mapped to G for example ?Please post more sample data and the corresponding expected result
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Mapping Item prices then selecting cheapest