cuong0202 > 19-04-13, 09:58 AM
SELECT phieunhapkho.sophieunhap, phieunhapkho.ngaynhap, phieunhapkho.nguoigiao, dmkhnccnv.tenkhnccnv, dmkhnccnv.dienthoai, dmkhnccnv.mail, dmkhnccnv.bophan, chitietnhapkho.mahangnhap, danhmuchanghoa.tenhang, danhmuchanghoa.donvitinh, chitietnhapkho.soluongnhap
FROM (dmkhnccnv INNER JOIN phieunhapkho ON dmkhnccnv.makhnccnv = phieunhapkho.nguoigiao) INNER JOIN (danhmuchanghoa INNER JOIN chitietnhapkho ON danhmuchanghoa.mahang = chitietnhapkho.mahangnhap) ON phieunhapkho.sophieunhap = chitietnhapkho.sophieunhapkho
WHERE (((phieunhapkho.sophieunhap)=[Forms]![FnhapnoiboMrdung]![sophieunhap] And (phieunhapkho.sophieunhap) Like "PN-FP*") AND ((chitietnhapkho.soluongnhap)>0));