list of items by supplier - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

list of items by supplier

Author

Topic

issam
Starting Member

30 Posts

Posted - 2008-01-14 : 07:15:37

Hi,

I have the following table Descriptions:-

Item No. -- Supp1-- Supp2-- Supp3 .... Supp10

I want to have a list of items for each supplier on the tables showing the following:-

Header is the Supplier No.
Details of each item Item No

Thanks for your help

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-01-14 : 07:37:11

1 Read about normalisation
2
Select supp1,itemNo from table
union all
Select supp2,itemNo from table
.
.
Select supp10,itemNo from table

Madhivanan

Failing to plan is Planning to fail

issam
Starting Member

30 Posts

Posted - 2008-01-14 : 08:45:30

thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources