Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multi-Join Query Returns Too Many Rows
I am trying to avoid multiple queries / putting data into temp tables and so am trying to write a query that will do two different sums off of the same table in one query. select s.name, sum(t1.Quantity), sum(t2.Quantity) from SecurityMaster s inner join Trades t1 on s.SecurityID =...
