Merajuddin Ansari

Merajuddin Ansari

  • NA
  • 90
  • 14.7k

SQL - Create view using sql command “UNION” from multiple ta

Nov 28 2015 4:11 AM

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

Answers (1)