sql - Different between mySQL queries INNER JOIN -


this question has answer here:

i have 2 queries:

$query = mysql_query("select ord.orderid, customers.customername,                              ord, customers                       customers.customersalary=ord.orderid"); 

and

$query = mysql_query("select ord.orderid, customers.customername,                        ord                       inner join customers                       on customers.customersalary=ord.orderid"); 

this queries return same result. different between them.

$query = mysql_query("select ord.orderid, customers.customername,                        ord                       inner join customers                       on customers.customersalary=ord.orderid"); 

this query optimised other 1 inner join applied first , clause applied.

other benifit see can change inner outer join.

clean code.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -