Select * from table1,table2

 Posted by Bunty_18 on 4/21/2010 | Category: Sql Server Interview questions | Views: 14591
Select from following answers:
  1. Inner Join
  2. Outer Join
  3. Cross Join
  4. None of the above
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Samanthajyesta on: 5/19/2010
It uses the cross join because column names are taken from more than one table.that means there must be a comman column in the all the tables(What ever the table number).
so it must be joined with a particular column.

Login to post response

More Interview Questions by Bunty_18