🚀 go-pugleaf

Hi,
    I am using a TADODataSet to query data from SQL Server 7, there are 2
table joined in SQL, like the following:

select od.OrderID, od.OrderDate, Cust.CustCode, od.BuyerRef, od.Brand,
od.ShippingMethod, od.ShipmentFrom, od.ShipmentTo, od.Consignee,
od.PaymentTerm, od.CreditDays, od.PriceTerm, od.ReqDeLvDate, od.ReqDateDes,
od.RealDelvDate,  od.RealDateDes, od.DelvCountry, od.PriceUnit, od.Quantity,
od.Amount, od.TotalWeight, od.TotalSize, od.Confirmation, od.Approved,
od.ApprovedBy, od.Status, od.OrderTypeID, od.DeptID  from Orders od left
join  Customers Cust on Cust.CustID = od.CustID where (od.OrderDate Between
:StartDate and :EndDate) and (od.DeptID = :DeptID or od.CustID = :CustID)

    When I delete a row from DataSet, I just want to delete the row in the
first table(Orders), Using DataSet->Delete(), but It also delete the second
table( Customers ) row, What's wrong with me.

    The following tracing message are from SQL Server Profiler after I
execute the delete operation:
sp_executesql N'DELETE FROM "CELDB".."Customers" WHERE "CustID"=@P1', N'@P1
varchar(12)', '2018        '
go
sp_executesql N'DELETE FROM "CELDB".."Orders" WHERE "OrderID"=@P1', N'@P1
varchar(20)', 'PI02D03051          '

    How can I delete only primary table row in a joined query?

    by the way, I'm using BCB5 and SQL7.

Thank you very much

Junlin Xie