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 |
|
vis_karthik@hotmail.com
Starting Member
2 Posts |
 Posted - 2006-06-19 : 12:28:56
|
| Have three tablesItemMaster (ItemPartNumber, DUNSVendorNUmber)Branches (Branch Number)CatalogViews (ItemPartNumber,DUNSVendorNUmber, Branch Number)The objective is to get those itempartnumbers from itemmaster for a particular DUNSVendorNumber that are not there in every branch in catalog viewsWould appreciate if any of you could help with this |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-19 : 12:44:56
|
quote:
...that are not there in every branch in catalog views
I am not sure of what you mean? Do you mean that every item should be in each Branch based on ItemMaster/Branches table and thus, if the CatalogViews does not have this combination, it will be reported? Or based on the CatalogViews, you come up with the list of ItempartNumber, Branch Number and if its not found with DUNSVendorNumber, it will be reported.May the Almighty God bless us all! |
 |
|
|
vis_karthik@hotmail.com
Starting Member
2 Posts |
Posted - 2006-06-19 : 12:56:45
|
| Every Branch Must have every itempartnumber from itemmaster in the catalog views table.eg.Branches--------0506605067ItemMaster DUNSVendorNumber---------- ----------------11192 0021644571119200 00216445711335 0021644571133500 00216445711336 0021644571133600 0021644574161 0021644574354 0021644574355 002164457CatalogViews------------ItemPartNumber DUNSVendorNumber Branch-------------- ---------------- ------4355 002164457 050674355 002164457 050664354 002164457 05067In In the above example item 4354 exist only for 05067. When we disply data it must display all itempartnumbers from itemmaster that do not have an entry for every branch. So since item 4354 is not there in CatalogViews for 05066 that should also be displayed. |
|
|
|
|
|
|
JOINS