[SQL]how to delete record where I reference to other table

Hi Has look alot around , and tried a lot without success how to do this : Delete from pproductMix PM where PM.mixID in (select ID from pmix where mixno=72000) I would like a solution with and without subqueries thanks Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL Gen

Re: [SQL]how to delete record where I reference to other table

"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: > Has look alot around , and tried a lot without success > > how to do this : > Delete from pproductMix PM where PM.mixID in (select ID from pmix > where mixno=72000) > > I would like a solution with and without subqueries > DELETE FROM pproductMi