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

Merajuddin Ansari

10y1kSQL

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

1 Reply

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

Priyank Patel10y ago
Hi, Merajuddin Ansari

I give you one solution which is quite long but it gives you proper result.

You can use Cross Apply.

For Ex.
select distinct result.* from
((select id, Name from Person)
union
(select id,Image 'Name' from ProductImage))
as tmp
Cross apply
(select top 1 * from
((select id, Name from Person) union (select id,Image 'Name' from ProductImage))as tmp1
where tmp.Id = tmp1.Id) result

Thanks,
Priyank