Because ADO could not correctly figure out how to construct the DELETE
Try to use this instead:
SELECT T1.Field1, T1.Field2,
FROM T1, T2 WHERE T1.IdField = T2.IDField
Sometimes this helps.
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
Quote:> I need help. Badly. I have a SQL query that joins a couple of tables
> like so:
> SELECT T1.Field1, T1.Field2,
> FROM T1 LEFT JOIN T1 ON T1.IDField = T2.IDField
> This is executed and creates an ADO recordset that I use in my app.
> When I go to delete a record from the recordset, the delete is deleting
> the record from T1 AND the record from T2. I do not have any relationships
> set between T1 and T2.
> Why is my .delete command deleting the record from T2? TIA, Wayne