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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mal55
  • Order by date
  1. mal55

    Multi-Join Query Returns Too Many Rows

    That solution has the merit of being correct, efficient and brilliant. Thanks!!!
  2. mal55

    Multi-Join Query Returns Too Many Rows

    Thanks for your thoughts. There is a one-to-many relationship between the SecurityMaster and the Trades table(the Trades table being the many). But what the query seems to be doing is relating the two Trades tables to one another and I can't see how that should be given that the Trades tables...
  3. mal55

    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 =...

Part and Inventory Search

Back
Top