SOLVED: Using SELECT within SELECT in mysql query
Hi,
finaly, the request is :
thank you.
SELECT DISTINCT ri4.item
FROM regroupement_item ri3
INNER JOIN regroupement rg3 ON rg3.regroupement_id = ri3.regroupement_id
INNER JOIN regroupement_item ri4 ON ri4.regroupement_id = rg3.regroupement_id
LEFT JOIN (SELECT rg1.regroupement_id, ri.item
FROM regroupement rg1
INNER JOIN regroupement_item ri ON rg1.regroupement_id = ri.regroupement_id
INNER JOIN regroupement_item ri2 ON ri2.item=ri.item
INNER JOIN regroupement rg2 ON rg2.regroupement_id = ri2.regroupement_id
WHERE rg1.regroupement_type = 1 AND rg2.regroupement_type = 2) gg ON gg.item = ri4.item
WHERE rg3.regroupement_type = 2 AND ri3.item != ri4.item AND gg.item IS NULL
Edited 1 time(s). Last edit at 03/22/2013 08:13AM by Peter Brawley.
Subject
Written By
Posted
SOLVED: Using SELECT within SELECT in mysql query
March 22, 2013 07:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.