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

[Kim G. Pedersen]

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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]