How to join two tables without having common column between them?

Posted by Bandi on 9/10/2013 | Category: Sql Server Interview questions | Views: 3266 | Points: 40

Answer:

Answer:
Using ON clause with true condition
i.e.

SELECT * 

FROM Table1

JOIN Table2 ON 1=1

Here 1=1 means always true condition for each row in table

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Why sometimes "NOT IN condition" will re ...

Next > : What are the Different ways of importing data into ...

More Interview Questions by Bandi

Latest Interview Questions