Delete a value from a column referred to two different table

Question

How would you delete a value from a column in a table when that column value refers to two different tables.

Need a SQL Query here using Joins