view union statement difference in quantity review
Posted on 2013-06-16
Hi I need to pull out some information on the first statement and
more information on the second union statement
the way to do it would be
create view sample_vw
order_no as [order no],
--a.branch_name as [branch name],
--c.phone as [mobile phone],
--salesperson as [Salesperson Name]
select order_no as [order_no], a.branch_name as [Branch Name], c.phone as [mobile], salesperson as [Salesperson name].
would that be correct.
first union statement I only want to show the order number nothing else, second union name i want other information.
how can you get a statement not to display in the results?