mysql - 我需要从两个计数表中减去..如何逐行减去，但它会从所有行中减去？

Question

select iname,icode,inpage,items 
from( (SELECT inid, COUNT(iid) - (select COUNT(iid) 
                                  From itemsd GROUP by iid ) AS items 
       FROM items 
       GROUP by inid) as item 
INNER JOIN (SELECT inid, iname,icode,inpage 
            FROM intype) AS itype ON item.inid = itype.inid)

标签： mysqlsql