[apostacy]

Anyone know if there's any possible difference between listing the tables and using a where clause to attach them, or using an inner join? (See below.)


select * from order_header, order_line
where order_header.order_no = order_line.order_no
and order_header.order_no = 100001


select * from order_header
inner join order_line on order_header.order_no = order_line.order_no
where order_header.order_no = 100001

[Tritium]

There is no difference between those, the default join is an inner join. Outer joins are different though.