maidinhdan > 01-03-15, 12:59 AM
SELECT QryTonDau.MaThuoc, QryTonDau.TenThuoc, QryTonDau.HamLuong, QryTonDau.DVT, QryTonDau.DonGia,
Sum(NZ([TonCu])) AS Cu, Sum(NZ([TongNhap])) AS Nhap, Sum(NZ([TongXuat])) AS Xuat
FROM (QryTonDau LEFT JOIN QryTongNhap ON QryTonDau.MaThuoc = QryTongNhap.MaThuoc) LEFT JOIN QryTongXuat ON
QryTonDau.MaThuoc = QryTongXuat.MaThuoc
GROUP BY QryTonDau.MaThuoc, QryTonDau.TenThuoc, QryTonDau.HamLuong, QryTonDau.DVT, QryTonDau.DonGia;