Hi:
I have an Append query, the data are from a SELECT:
So it looks like this:
INSERT INTO tblA (colA1,colA2...)
SELECT (qryMySelect.colB1, qryMySelect.colB2...)
FROM (qryMySelect)
qryMySelect is a query that get data from other 2 tables (tblX, tblY), if the qryMySelect runs a Inner Join (..FROM [tblX] INNER JOIN tblY ON tblX.CaseID = tblY.CaseID) , the append query works fine.
But if the qryMySelect runs a left join(FROM [tblX] LEFT JOIN tblY ON tblX.CaseID = tblY.CaseID) that I will get more rows of data, but the append query will popup error: "Record is deleted".
Is there any restriction on running the append query?
Thanks a lot.
JT
I have an Append query, the data are from a SELECT:
So it looks like this:
INSERT INTO tblA (colA1,colA2...)
SELECT (qryMySelect.colB1, qryMySelect.colB2...)
FROM (qryMySelect)
qryMySelect is a query that get data from other 2 tables (tblX, tblY), if the qryMySelect runs a Inner Join (..FROM [tblX] INNER JOIN tblY ON tblX.CaseID = tblY.CaseID) , the append query works fine.
But if the qryMySelect runs a left join(FROM [tblX] LEFT JOIN tblY ON tblX.CaseID = tblY.CaseID) that I will get more rows of data, but the append query will popup error: "Record is deleted".
Is there any restriction on running the append query?
Thanks a lot.
JT