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
Post a Comment