I first apologize if this is in the wrong forum. I am new to SQL and I have a stored procedure question. I have 2 tables that I need to combine into one temp table.
Table One (Distributor Information): DistributorID
Tables Two (Item Information): Item Number, Class ID
I need to create a tables that will include all the item numbers and classid based on any criteria I choose (I can do the WHERE clause of the SQL statement) and then also have the distributorID in each record.
For instance:
DistributorID Item Number ClassID
101 STA-P1 Nexa
101 STA-P2 Nexa
101 STA-P3 Nexa
101 STA-P4 Nexa
102 STA-P1 Nexa
102 STA-P2 Nexa
102 STA-P3 Nexa
102 STA-P4 Nexa
103 STA-P1 Nexa
103 STA-P2 Nexa
103 STA-P3 Nexa
103 STA-P4 Nexa
I am not real sure how to do this and there is no fields that I can join the tables with. Any Idea?
Thanks in advance
Table One (Distributor Information): DistributorID
Tables Two (Item Information): Item Number, Class ID
I need to create a tables that will include all the item numbers and classid based on any criteria I choose (I can do the WHERE clause of the SQL statement) and then also have the distributorID in each record.
For instance:
DistributorID Item Number ClassID
101 STA-P1 Nexa
101 STA-P2 Nexa
101 STA-P3 Nexa
101 STA-P4 Nexa
102 STA-P1 Nexa
102 STA-P2 Nexa
102 STA-P3 Nexa
102 STA-P4 Nexa
103 STA-P1 Nexa
103 STA-P2 Nexa
103 STA-P3 Nexa
103 STA-P4 Nexa
I am not real sure how to do this and there is no fields that I can join the tables with. Any Idea?
Thanks in advance