Join records of two Select query using UNION in SQL Server

SUJAYS

How to union the two same query as treeview?

select menuname,menuid,formname from Hdmaster where menuid=91

select menuname,menuid,formname from Hdmaster
where menuname='Configuration'

dharmend...

0 1

Use Union statement like the below query.

Make sure both the select query have same number of columns.

SELECT menuname,menuid,formname 
FROM Hdmaster WHERE menuid=91
UNION
SELECT menuname,menuid,formname 
FROM Hdmaster WHERE menuname='Configuration'

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html