Hi All

I am trying to do a delete for a row where the the condition relate to two tables. In my reading i found an example using left join for a select and it's equivalent delete statement. I tried the same thing on my db, my select statement worked fine but my delete statement didn't and it was the delete statement i was interested in.

Select statement;
SELECT t_profit_payment.* from t_profit_payment LEFT JOIN t_repayment ON t_profit_payment.AcctID = t_repayment.AcctID where t_repayment.ID = 29

Delete Statement
DELETE t_profit_payment from t_profit_payment LEFT JOIN t_repayment ON t_profit_payment.AcctID = t_repayment.AcctID where t_repayment.ID = 29

IF anyone can help it would be most appreciated.

Thanks in advance