What is the diffrence between these two sql qry?

Question

please tell me the diff
select supplier.sup_id from supplier,product where supplier.sup_id=product.sup_id
order by supplier.sup_id
select supplier.sup_id from supplier,product where supplier join product
supplier.sup_id=product.sup_id
order by supplier.sup_id

Andrew Fenster · Answer

The second one is not proper SQL syntax.  It should be:
select supplier.sup_id
from supplier join product
on  supplier.sup_id=product.sup_id
order by supplier.sup_id
This should return the same data as the first query.

Javeed M Shaikh · Answer

Hi Amol,
The first query will inner join supplier and product and return sup_id from supplier table ordering the results by sup_id from supplier table.
The second query will give an error as I am not aware of any SQL syntax which has join keyword in the where clause.
Please do not forget to mark "Accepted Answer".