2 SQL-Abfragen kombinieren

[Union]

Ungetestet (ob MYSql das mit dem Group und nicht-Aggregaten gemischt hinbekommt ist eine andere Sache):

SQL-Code:

SELECT subquery1.Id,
       subquery1.citemname,
       subquery1.level,
       subquery1.itemname as aitemname,
       subquery1.Anzahl1,
       subquery2.Anzahl2
FROM
(    
   SELECT c.id, c.itemname, a.alevel, a.itemname, count(s.id) As Anzahl1 
         FROM tblcats c 
         LEFT JOIN tblsubcats s 
         ON c.id = s.parentcat 
         INNER JOIN tblaccesslevels a 
         ON c.alevel = a.alevel 
         WHERE s.alevel <= 1 
         GROUP BY c.itemname
) subquery1
LEFT OUTER JOIN
(
SELECT c.id, c.itemname, a.alevel, a.itemname, count(p.id) As Anzahl2 
      FROM tblcats c 
      LEFT JOIN tblsubcats s 
      ON c.id = s.parentcat 
      LEFT JOIN tblpics p 
      ON p.parentsubcat = s.id 
      INNER JOIN tblaccesslevels a 
      ON c.alevel = a.alevel 
      WHERE s.alevel <= 1 
      GROUP BY c.itemname
) subquery2 on subquery1.id = subquery2.id