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

 Posted by Bandi on 9/10/2013 | Category: Sql Server Interview questions | Views: 2038 | 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 

Comments or Responses

Login to post response