Loading

Join query in sql database

Micalgray

Hi,

I want to join two tables using join operator and also perform delete operation with the join query. How can do that ? Anyone can tell me............

2 Replies

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

geetha geetha4y ago
You have to use innerjoin operation for joining two tables.
here I attached a screenshot :
You also perform delete operation also:
   DELETE [Table_1]
    FROM    [Table_1]
            INNER JOIN [Table_2]
    ON [Table_2] .[Employee ID] = [Table_2] .[Employee ID]

Alternate solution for delete query:
delete from Table_1 , Table_2 where Table_1.Employee ID= Table_2.Employee ID

0
Om prakash Singh15y ago
to fetch data, use this query:-
select * from table1 a,table2 b where a.id=b.id
to delete data, use this query:-
delete from table 1 where id in(select id from table1 a, table2 b where a.id=b.id)
or
delete from table1 a,table2 b where a.id=b.id
0