I want to delete a record from a single table but some of the filed on sigle record is related to other table on my database.
how would i delete it..
i used this script
delete from faculty deptid = (select deptCode from dept)
all i want is to remove the single faculty record on the faculty table only...