Home Forums SQL Server 2008 T-SQL (SS2K8) problem with join T-Sql RE: problem with join T-Sql
davidandrews13
SSCertifiable
Points: 6792
More actions
February 12, 2013 at 3:15 am
#1586898
i think it is valid syntax, its just giving a cross join because there isn't a join in the WHERE clause.
select
*
from
table1 t1
,(select ...) t2
where
t1.col1 = t2.col1
jasons example is a good modification, though. i would go with his update.