Finding Duplicates in LEFT JOIN
This may appear extrememly convoluted by here is the query you need

select * from
(select count(1) dupcount,emp_name,dept_name from table_a group by emp_name,dept_name) as a
left join
(select count(1) dupcount,emp_name,dept_name from table_b group by emp_name,dept_name) as b
on a.emp_name = b.emp_name and a.dept_name = b.dept_name where a.dupcount &lt;&gt; IFNULL(b.dupcount,0);


I loaded you sample data and I got this:

mysql&gt; select * from
    -&gt; (select count(1) dupcount,emp_name,dept_name from table_a group by emp_name,dept_name) as a
    -&gt; left join
    -&gt; (select count(1) dupcount,emp_name,dept_name from table_b group by emp_name,dept_name) as b
    -&gt; on a.emp_name = b.emp_name and a.dept_name = b.dept_name where a.dupcount &lt;&gt; IFNULL(b.dupcount,0);
+----------+----------+------------------------+----------+----------+-----------+
| dupcount | emp_name | dept_name              | dupcount | emp_name | dept_name |
+----------+----------+------------------------+----------+----------+-----------+
|        2 | amar     | finance                |        1 | amar     | finance   |
|        1 | anthony  | information_technology |     NULL | NULL     | NULL      |
+----------+----------+------------------------+----------+----------+-----------+
2 rows in set (0.02 sec)

mysql&gt;


Here is it without the dupcount values

mysql&gt; select a.emp_name,a.dept_name,b.emp_name,b.dept_name from
    -&gt; (select count(1) dupcount,emp_name,dept_name from table_a group by emp_name,dept_name) as a
    -&gt; left join
    -&gt; (select count(1) dupcount,emp_name,dept_name from table_b group by emp_name,dept_name) as b
    -&gt; on a.emp_name = b.emp_name and a.dept_name = b.dept_name where a.dupcount &lt;&gt; IFNULL(b.dupcount,0);
+----------+------------------------+----------+-----------+
| emp_name | dept_name              | emp_name | dept_name |
+----------+------------------------+----------+-----------+
| amar     | finance                | amar     | finance   |
| anthony  | information_technology | NULL     | NULL      |
+----------+------------------------+----------+-----------+
2 rows in set (0.00 sec)

mysql&gt;


Give it a Try !!!