Hi,

My question is what is the difference between these two?

1)Select * from sales join stores on sales.stor_id=stores.stor_id

2)Select * from sales,stores where sales.stor_id=stores.stor_id

Expecting reply,
Ramkumar

A.D.Ramkumar

__________________
Ramkumar A D

The former is the new join style and compliant with the ANSI SQL-92 standard, the latter is the old join style. There's no loss in performance in either style, the only benefit is the new join style is slightly more verbose. In addition, the Old Outer Join Style *= and =* is now redundant.