Very Computer

Because ADO could not correctly figure out how to construct the DELETE
query?
Try to use this instead:

SELECT T1.Field1, T1.Field2,
               T2.Field1
                FROM T1, T2 WHERE T1.IdField  = T2.IDField

Sometimes this helps.

--
____________________________________
Bill Vaughn
www.betav.com
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
> together
> like so:

> SELECT T1.Field1, T1.Field2,
>                T2.Field1
>                 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

I need help. Badly. I have a SQL query that joins a couple of tables
together
like so:

SELECT T1.Field1, T1.Field2,
               T2.Field1
                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