CODEWITHSUNDEEP
sqlsql-serversql-server-2008
BinaryOf Sam
BinaryOf Sam

Reputation: 113

How to get cross join result from inner join

Question from my last interview - Can we get cross join result from inner join without using cross join statement in sql server ?

Upvotes: 0

Views: 105

Answers (1)

BinaryOf Sam
BinaryOf Sam

Reputation: 113

Answer is already there in comment,

SELECT * 
FROM TableA 
INNER JOIN TableB ON 1=1

Upvotes: 1

Related Questions