Select * from table1,table2

Posted by Bunty_18 on 4/21/2010 | Category: Sql Server Interview questions | Views: 16091

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Select from following answers:

Inner Join
Outer Join
Cross Join
None of the above
All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Can we Add New Row into a Grid Using Binding Sourc ...

Next > : what is the difference between garbage collection ...

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.

More Interview Questions by Bunty_18

Latest Interview Questions

what is the difference between garbage collection and Dispose Method
Is it possible to find out .mdf and .ldf file name from the backup(.ba ...
Can we restore the database forcefully when it is in use via SQL scrip ...
Can we execute "BCP" command directly in the SQL Server Mana ...
What are Properties in .NET, What are the advantages of using Properti ...
Difference between function Overloading and Overriding ?
What is Method Hiding?
What are the differences between value types and reference types?
More ...