trinhviettt
Thành viên mới
- Tham gia
- 10/7/08
- Bài viết
- 7
- Được thích
- 1
chào các anh chị.
anh chị nào giúp em tìm lỗi của câu lệnh SQL này với
Sqlstr = ""
Sqlstr = Sqlstr + " INSERT INTO TRA015 "
Sqlstr = Sqlstr + " SELECT DISTINCT MAINITEMNAME "
Sqlstr = Sqlstr + " FROM Q_R_Process_QtyV3 "
Sqlstr = Sqlstr + " WHERE PROCESSCODE <> '999'"
Sqlstr = Sqlstr + " UNION "
Sqlstr = Sqlstr + " SELECT DISTINCT MAINITEMNAME "
Sqlstr = Sqlstr + " FROM Q_R_Process_QtyV3 "
Sqlstr = Sqlstr + " WHERE PROCESSCODE ='999' "
Sqlstr = Sqlstr + " AND ITEMNAME IN "
Sqlstr = Sqlstr + " (SELECT T1.SRCITEMNAME "
Sqlstr = Sqlstr + " FROM TBL003 T1,"
Sqlstr = Sqlstr + " Q_R_Process_QtyV3 T2 "
Sqlstr = Sqlstr + " WHERE T1.DSTITEMNAME =T2.ITEMNAME "
Sqlstr = Sqlstr + " AND T2.PROCESSCODE ='501')"
DB.Execute Sqlstr
anh chị nào giúp em tìm lỗi của câu lệnh SQL này với
Sqlstr = ""
Sqlstr = Sqlstr + " INSERT INTO TRA015 "
Sqlstr = Sqlstr + " SELECT DISTINCT MAINITEMNAME "
Sqlstr = Sqlstr + " FROM Q_R_Process_QtyV3 "
Sqlstr = Sqlstr + " WHERE PROCESSCODE <> '999'"
Sqlstr = Sqlstr + " UNION "
Sqlstr = Sqlstr + " SELECT DISTINCT MAINITEMNAME "
Sqlstr = Sqlstr + " FROM Q_R_Process_QtyV3 "
Sqlstr = Sqlstr + " WHERE PROCESSCODE ='999' "
Sqlstr = Sqlstr + " AND ITEMNAME IN "
Sqlstr = Sqlstr + " (SELECT T1.SRCITEMNAME "
Sqlstr = Sqlstr + " FROM TBL003 T1,"
Sqlstr = Sqlstr + " Q_R_Process_QtyV3 T2 "
Sqlstr = Sqlstr + " WHERE T1.DSTITEMNAME =T2.ITEMNAME "
Sqlstr = Sqlstr + " AND T2.PROCESSCODE ='501')"
DB.Execute Sqlstr
