About deleting.

From: kolja2003 (NOSPAM_at_list.ru)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 22:51:32 +0300

I open ADO dataset by inserting to ADOQUERY.SQL:
----------------------
SELECT [S.StockNo], [S.Article], [S.Name], [S.Producer],
       [I.ItemNo], [I.InvoiceNo], [I.StockNo], [I.Price], [I.Qty]
FROM Items I LEFT JOIN Stock S ON (I.StockNo= S.StockNo)
WHERE (I.InvoiceNo= :InvoiceNo)
---------------------
I get result dataset. I updates fields of table Items, everything works OK.
Then I try to delete record.
For my wonder I get records of 2 tables Items&Stock deleted. I didn't want
to change table Stock so I want to delete only in table Items.
How to do this? I need to change SQL or there are more fine solution?