problem in inner join

[Guest anbu]

what is the query to delete the fields of two tables which are already joined by inner joinfor example table cust nameage addidtable prdpidpnameselect cust.name,cust.age,cust.add ,prd.pid from cust inner join prd on cust.id=prd.pid

[aspnetguy]

You cannot runa delte staement in a select statement...i think.try some like this

DELETE FROM cust c, prd pWHERE c.id = p.pid  --if these are the sameAND {some condition for table cust}AND {some condition for table prd}