Mysql query returns 0 rows when not using a table mentioned in "FROM" -


this query returns 0 elements:

select `table1`.`id` `table1`,`table2` `table1`.`id`='222' ; 

however expect have result because query returns 1 element:

select `table1`.`id` `table1` `table1`.`id`='222' ; 

is there mysql parameter set in order result first query table2 not used?

in first query used 2 table in second query used 1 table.because of result different.

if not specify join explicitly use cartesian product


Comments

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

Pull out data related to my apps from Android Play Store and iOS App Store -

How can I fetch data from a web server in an android application? -