otoceni podminky JOIN do stejne tabulky
- kopa
- Člen | 29
Zapasim s chybnym pripojenim stejne tabulky.
$data->joinWhere(":commodity","commodity.commodity_id = :commodity.id");
kde vysledny sql je
LEFT JOIN `commodity` `commodity_ref` ON `commodity`.`id` = `commodity_ref`.`commodity_id` AND
(`commodity`.`commodity_id` = `commodity_ref`.`id`)
Diky za pomoc ;)