I have two master tables namely Shape and Color.Which type of join will you use to map all the records of Shape table with all the records of Color table.(Get the Cartesian product of the both table row sets).

Shape table:
iShapeID sShapeName iShapeArea
1 Circle 12
2 Square 8
3 Rectangle 40
4 Triangle 15

Color Table:
iColorID sColorName
1 Yellow
2 Green
3 Orange
4 Blue
5 Rose

 Posted by Nagasundar_Tn on 11/28/2012 | Category: Sql Server Interview questions | Views: 2645 | Points: 40
Select from following answers:
  1. Inner Join
  2. Left Outer Join
  3. Self Join
  4. Cross Join
  5. All Above

Show Correct Answer


Asked In: NIIT Interview | Alert Moderator 

Comments or Responses

Login to post response