Web Development

Ask something
Question Locked

Union of two queries using vb6.0 coding

0 helpful
2 replies

by srbatcha

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have two query:

#1. Year wise Report:

rec.Open "select Sales_Person_ID,Employee_Name,sum(Total_value),div ision_name,segment_name from segment_trans where (segment_trans.date >= #" & (fdate.Text) & "# and segment_trans.date<= #" & (tdate.Text) & "# ) GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic

#2. Month wise Report:

rec1.Open "select Sales_Person_ID,Employee_Name,sum(Total_value),div ision_name,segment_name from segment_trans where (segment_trans.date >= #" & (Text3.Text) & "# and segment_trans.date<= #" & (Text4.Text) & "# ) GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic

How to connect this two Queries with in one Query?

please help me.

Thanks
sathik

2 replies

by tony hopkinson

SElect * From (
select
Sales_Person_ID,
Employee_Name,
sum(Total_value) as Total_Value,
division_name,
segment_name
from segment_trans
where (segment_trans.date >= #" & (fdate.Text) & "# and segment_trans.date<= #" & (tdate.Text) & "# )
GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name
UNIONALL
select
Sales_Person_ID,
Employee_Name,
sum(Total_value),
division_name,
segment_name
from segment_trans where (segment_trans.date >= #" & (Text3.Text) & "# and segment_trans.date<= #" & (Text4.Text) & "# )
GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name
) dummyname
order by division_name,segment_name"

This discussion is closed to new replies.