i have 3 tables for example tb1,tb2,tb3 and each table include same data for different different company, so i want to get all 3 table data in a view when i do "union" its sowing duplicate data also. the reason is, not having same data in each column for duplicate rows. like below, can any one please help me. i want only one row from below
ex:-
emp_no emp_name emp_addr emp_ph
101 abcd xloc 000000
101 abcd null 000000