Posted - 08/25/2014 : 01:32:25
| 1)Table Name - Segementation
- ID (primary Key)
2) Table name- Btype
-ID (primary Key)
3)Table name - SegmentBrelationship
-Id (primary key)
-SegID (Foreign key) (from Table Segmentation)
-BTID (Foreign key) (from Table -Btype)
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.