why show "Record is deleted" (1 Viewer)

[jamest85]

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

 

[jamest85]

sorry, I thought I figured out, but in fact not yet, any suggestion?