🚀 go-pugleaf

Hej NG.

Jeg har f�lgende problem.
Jeg skal have valgt f�lgende:

SELECT et_products_phones.id AS phone_id, et_products_phones.name AS
phone_name , et_product_accessories_rel.product_id AS check_id ,
et_product_groups.name AS type
FROM et_products_phones
LEFT JOIN et_product_accessories_rel ON et_products_phones.id =
et_product_accessories_rel.phone_id
LEFT JOIN et_product_groups ON et_products_phones.group_id =
et_product_groups.id
GROUP BY et_products_phones.id
ORDER BY et_products_phones.group_id, et_products_phones.id,

Dette er i og forsig fint nok; mit problem er at jeg hvis der findes en post
i et_product_accessories_rel med et_product_accessories_rel
.product_id=[v�rdi1] skal have denne r�kke, og hvis ikke en r�kke hvor denne
v�rdi er tom.
Det t�tteste jeg kan komme er hvis jeg benytter;

SELECT et_products_phones.id AS phone_id, et_products_phones.name AS
phone_name , et_product_accessories_rel.id AS check_id ,
et_product_groups.name AS type
FROM et_products_phones
LEFT JOIN et_product_accessories_rel ON et_products_phones.id =
et_product_accessories_rel.phone_id
LEFT JOIN et_product_groups ON et_products_phones.group_id =
et_product_groups.id
WHERE (et_product_accessories_rel.product_id='[v�rdi1]' OR
et_product_groups.id is not null)
GROUP BY et_products_phones.id
ORDER BY et_products_phones.id, et_products_phones.group_id

men hvis der er en r�kke i et_product_accessories_rel hvor
et_product_accessories_rel .product_id er forskellig fra [v�rdi1] udelades
hele denne r�kke (alts� ogs� relationerne til de andre tabeller)

Kan dette l�ses, og i s� fald hvorledes.
Jeg benytter MySQL, og kan s�ledes ikke benytte SubSelects.

MVH
Christian Bruhn Gufler