Hallo,
habe folgende zwei funktionierende Abfragen:
SELECT hp5_mtr_id, hp2_adrid, hp5_ptrid, SUM(IF(hp5_ptrid=163,1,0)) AS hp5_ptrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp2_adrid ORDER BY hp2_adr_firma1
SELECT hp5_mtr_id, hp2_adrid, hp5_ptrid, SUM(IF(hp2_adrid=163,1,0)) AS hp5_adrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp5_ptrid ORDER BY hp2_adr_firma1
Wollte jetzt beide Abfragen zusammenfassen zu ...
SELECT hp5_mtr_id, hp2_adrid, SUM(IF(hp2_adrid=163,1,0)) AS hp5_adrid_subscribed, hp5_ptrid, SUM(IF(hp5_ptrid=163,1,0)) AS hp5_ptrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp2_adrid, hp5_ptrid ORDER BY hp2_adr_firma1
was aber leider zu einem falschen Ergebnis führt. Liegt vermutlich am GROUP BY ... oder was mache ich falsch?
Danke im voraus
habe folgende zwei funktionierende Abfragen:
SELECT hp5_mtr_id, hp2_adrid, hp5_ptrid, SUM(IF(hp5_ptrid=163,1,0)) AS hp5_ptrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp2_adrid ORDER BY hp2_adr_firma1
SELECT hp5_mtr_id, hp2_adrid, hp5_ptrid, SUM(IF(hp2_adrid=163,1,0)) AS hp5_adrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp5_ptrid ORDER BY hp2_adr_firma1
Wollte jetzt beide Abfragen zusammenfassen zu ...
SELECT hp5_mtr_id, hp2_adrid, SUM(IF(hp2_adrid=163,1,0)) AS hp5_adrid_subscribed, hp5_ptrid, SUM(IF(hp5_ptrid=163,1,0)) AS hp5_ptrid_subscribed, hp5_olstatid, hp2_adr_id, hp2_adr_firma1, hp2_adr_nname1 FROM hp2_address, hp5_monitoring WHERE hp2_adr_id = hp2_adrid OR hp2_adr_id = hp5_ptrid GROUP BY hp2_adrid, hp5_ptrid ORDER BY hp2_adr_firma1
was aber leider zu einem falschen Ergebnis führt. Liegt vermutlich am GROUP BY ... oder was mache ich falsch?
Danke im voraus