Home Forums SQL Server 2008 T-SQL (SS2K8) join on 1=1 RE: join on 1=1
sqlfriend
SSC Guru
Points: 52769
More actions
November 9, 2011 at 11:10 am
#1405396
so if I change the join to cross join and take off 1=1, it will be the same, correct?
But I read somewhere if a cross join have a where clause, it is the same as inner join,
is it true for this case?
Thanks