G
Guest
HI Experts,
I have to delete data from 1 table based on condition from other table.
eg:-
Table1 fields are ID & Name
& Table2 fields are ID & Name .
Now i want to delete those records from Table1 in which ID does not match
with that of table 2.
ID is the primary key.
I have tried many things but it is not working.
Help Required......
can anyone write that SQL statement for me..............
Plz help
I have to delete data from 1 table based on condition from other table.
eg:-
Table1 fields are ID & Name
& Table2 fields are ID & Name .
Now i want to delete those records from Table1 in which ID does not match
with that of table 2.
ID is the primary key.
I have tried many things but it is not working.
Help Required......
can anyone write that SQL statement for me..............
Plz help