CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT label_id,label,COUNT(label) AS qnty_stock FROM stock GROUP BY label
- UNION
- SELECT label_id,label,COUNT(label) AS qnty_tranzit FROM tranzit WHERE sht="Stock" GROUP BY label