I know this is possble, but how? I'm currently running one select three delete sql statements in one function. How can I select the required value (need this to determine which record to delete in one case) and delete from all 3 tables using one statement. Thanks any help would be appreciated. Also I know that its a syntax issue and its supposed to work but I need syntax more than anything so any point in the direction of a tuturial or sample will be well taken. Basically I need to see how it can be done if possible. Thanks.