Home Forums SQL Server 2008 T-SQL (SS2K8) join on 1=1 RE: join on 1=1
John Michael Robertson
SSC Eights!
Points: 988
More actions
November 9, 2011 at 11:01 am
#1405389
I have seen this used many times as well. It basically satisifies the syntax requirement of the "JOIN" clause without any joining fields. Produces same result as a "cross join".