Hallo,
Zitat von
omata:
SQL-Code:
SELECT g.id, g.parent, g.itemlevel, g.name, cg.contact_id
FROM groups g
LEFT JOIN contacts2groups cg
ON g.id = cg.group_id
AND cg.group_id = 1
zeigt mir auch die contact_id nicht an. So geht es:
SQL-Code:
SELECT g.id, g.parent, g.itemlevel, g.name, cg.contact_id
FROM groups g
LEFT JOIN contacts2groups cg
ON g.id = cg.group_id
AND cg.contact_id = 1
@omata, hattest du das wieder geändert?
Viele Grüße ...