iBase.ru Forum

Код: Выделить всё

SELECT g.goods_id, g.category_id,
      (SELECT count(*) FROM base b WHERE b.goods_id=g.goods_id
                                     AND b.order_num IS NULL
                                     AND b.warranty_date is NULL)-
        (SELECT COUNT(*) FROM comps cm WHERE cm.goods_id=g.goods_id
                                         AND cm.metka in (1,2)),
      (SELECT COUNT(*) FROM comps cm1 WHERE cm1.goods_id=g.goods_id
                                        AND cm1.metka in (1,2))
FROM goods g