Mam taki problem mam sobie kilka tabel
Tak wyglądają te tabele
Products
id name
Substances
id name
Groups
id name
Forwarding_substances
id_groups id_substances
Forwarding_products
id_substances id_products
usee
id id_products date
I teraz Jak wpisze że produkt chcę wyszukać to wszystko jest dobrze, ale jak grupę wpisze to nic nie wyszukuje
select * from `usees` left join `products` on `products`.`id` = `usees`.`id_products` left join `forwarding_substances` on `forwarding_substances`.`id_products` = `forwarding_substances`.`id_substances` left join `substances` on `forwarding_substances`.`id_substances` = `substances`.`id` left join `forwarding_groups` on `forwarding_groups`.`id_groups` = `forwarding_substances`.`id_substances` left join `groups` on `groups`.`id` = `forwarding_groups`.`id_groups` where `substances`.`name` = 'lit'
W tym przypadku nic nie wyszukuje
select * from `usees` left join `products` on `products`.`id` = `usees`.`id_products` left join `forwarding_substances` on `forwarding_substances`.`id_products` = `forwarding_substances`.`id_substances` left join `substances` on `forwarding_substances`.`id_substances` = `substances`.`id` left join `forwarding_groups` on `forwarding_groups`.`id_groups` = `forwarding_substances`.`id_substances` left join `groups` on `groups`.`id` = `forwarding_groups`.`id_groups` where `products`.`name` = 'lit'
A w tym wyszukuje, próbowałem też ze zwykłym jointem, ale to samo.