Home Forums SQL Server 2005 T-SQL (SS2K5) Cartesian product! RE: Cartesian product!
pdross2000
Old Hand
Points: 363
More actions
November 18, 2007 at 10:20 pm
#752142
why no inner join?
select x.col1, x.col2, y.col3, y.col4
from TabA as x
inner join
TabB as Y
on x.col11 = y.coll11
where x.col11 = 'A'