I have a "Customers" table with auto id field "CustomerID". CustomerID appears as a foreign key in 4 other tables in the same database.

I only want to allow the user to delete a customer that has no related records. I could check each of the 4 tables for the existence of a particular CustomerID but is there a single SQL join statement that I could use to determine whether there are any related records throughout the 4 tables.