how can i put the two queries below to get one result set? join the two select statement with UNION .

select distinct g.servername,g.name,g.logical_name

from ip.azr_files g

full join ip.azr_names d

on g.servername= d.servername

where left (g.logical_name,1) not in ('c') or

g.name='model' and left (g.logical_name,1) <> 'H'

Select distinct servername, drive_id

from ip.azr_names

where left (drive_id,1) not in ('c' 's')

#sqlserver #database