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
 Joined SQL Query

Author  Topic 

teamjai
Yak Posting Veteran

52 Posts

Posted - 2014-08-25 : 01:32:25
1)Table Name - Segementation
- ID (primary Key)
- Producttype
- Material

2) Table name- Btype
-ID (primary Key)
-Bcode

3)Table name - SegmentBrelationship
-Id (primary key)
-SegID (Foreign key) (from Table Segmentation)
-BTID (Foreign key) (from Table -Btype)
-Material

i need joined SQL query with following tables and fields would be needed for helping to cross check whether all correct materials are assigned.

Could you please help me.


ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-25 : 06:00:43
where are you stuck?

Javeed Ahmed
Go to Top of Page
   

- Advertisement -