DaniWeb IT Discussion Community - View Single Post - Converting queries from MySQL 4 to MySQL 5

Re: Converting queries from MySQL 4 to MySQL 5

Dec 1st, 2008

lol easiest way to explain it is be specific

FROM table1, table2 JOIN table3 on id = table3.id

who knows what that means

now this

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
FROM table1 INNER JOIN table2 on table1.id = table2.id 
INNER JOIN table 3 on table3.id = table2.id
from table1 inner join table2 on table1.id = table2.id 
inner join table 3 on table3.id = table2.id

looks much clearer at least to me

Custom Application & Software Development
www.houseshark.net