deleting data

[orajit]

I have two tables say EmpA and EmpB


I wanted to delete data from EmpA That data there in EmpB

can u do that ..

Thanks in advance .

[r035198x]

1.) Always back up before deleting.
2.) How are you determining that data in A is in B? i.e What are you using to identify the data?

[vijayg14]

Hi,

for this use this query



delete from table a where <condition>

[amitpatel66]

Yes you can do that.....

Hint: Use DELETE statement and IN operator in the WHERE condition