Click here to Skip to main content
15,891,431 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello every budy. I am developing an windows application..
i have a query like
SQL
Select estdate as date,SUM(netamt) as total from estimate_first group by estdate union select ivdate,SUM(netamt) from invoice_first group by ivdate
Select DATE,SUM(totalAmount) from stock_update_first group by Date


i want to make a single select query for both of the queries i have tried joins but not get desired please solved ..i want a single table for both of the queries...
Posted
Updated 12-Nov-13 1:38am
v2

1 solution

use Union All for this situation
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900