Loading

Not delete record the record are exsting anther table

chiranjit das

10y937.NET

Dear sir

sir i have create two table and i try to one table record existing anther table i have delete first table record then record are not delete because first table data are existing second table

please help me

how to solve this

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel10y ago
Hi ,

if your table have proper relationship. primary key and foreign key.

right click on second table(which contain the primary key of first table) click on Design and then go to Relationship Icon click on it and make Delete Rule as Cascade.

if you are deleting the record of first table all related table should be deleted.
0

Amit Kumar Singh10y ago

1.

delete   from tableA  where exists        ( select 1             from tableB           where email = tableA.email )

2.delete tableA   from tableA inner    join tableB      on tableA.email = tableB.email

0