It's basically doing a cross join. Maybe the author didn't know about that option.

sqlfriends (11/9/2011)

---

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

select a.*, b.*
from a,b

select a.*,b.*
from a CROSS JOIN b

select a.*,b.*
from a INNER JOIN b
on 1=1 -- fake condition to satisfy INNER JOIN syntax.

Dev @ +91 973 913 6683 (11/10/2011)

---

I haven't seen any instance when people use 1=1 by mistake. It's deliberate CROSS JOIN (just to skip code review tools / team leads )