Shigeshi Hitoshi > 11-09-13, 05:40 PM
SELECT F21, F22, F23, F24, F25, F26, F27, F28, F29, F30
FROM Journal_Import
WHERE Journal_Import.F30 or Journal_Import.F21;
INSERT INTO test1 ( SoHD, NgayNhan, TenKhachHang, MST, MatHang, GiaChuaThue, ThueSuat, Thue, GhiChu, LoaiHD )
SELECT F21, F22, F23, F24, F25, F26, F27, F28, F29, F30
FROM Journal_Import
WHERE Journal_Import.F30 or Journal_Import.F21 AND NOT EXISTS ( SELECT SoHD
FROM test1
WHERE test1.SoHD = Journal_Import.F21 or test1.LoaiHD = Journal_Import.F30);