Using WHERE statement after UNION in SQL Server

SajidHus...

SOLVED CLOSED ACTIVE ANSWERED
User: SajidHussa
Posted: on Aug 24, 2021 01:53 AM
Forum: SQL Server
Answer: 1
Views: 1453

i want implement where clause in this query

my query is

select itemgroupname,itemgroupid ,'','' from tbl_itemgroup 
union 
select itemsubgroupname,itemgroupid,itemsubgroupid,'' from tbl_itemsubgruop 
union 
select proname,itemgroupid,itemsubgroupid,pid from tbl_productentry

where itemgroupname = na

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Aug 24, 2021 01:53 AM
Report

Hi SajidHussa,

Refer below query.

SQL

SELECT * FROM (
	select itemgroupname,itemgroupid ,'','' 
	from tbl_itemgroup 
	union 
	select itemsubgroupname,itemgroupid,itemsubgroupid,'' 
	from tbl_itemsubgruop 
	union 
	select proname,itemgroupid,itemsubgroupid,pid 
	from tbl_productentry
) t
where t.itemgroupname = 'na'

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

Using WHERE statement after UNION in SQL Server

Company

Explore

Follow us

Contact Us