You want any 1 of the date to be valid ..isnt it?


select count(*) from Emp_main a,Emp_sup b
where (a.date1 is not null OR a.date2 is not null)
and a.emp_no=b.emp_no
and b.loc='Bangalore'