Forum Replies Created

Viewing 6 posts - 1 through 7 (of 7 total)

  • RE: Northwind Querry INNER JOIN GROUP BY

    tfifield (2/20/2011)

    eh936,

    I'm curious as to exactly what the error message is then. I looked over my query and I can't see an error in it and I don't have...

    February 23, 2011 at 6:37 pm

    #1290700

  • RE: Northwind Querry INNER JOIN GROUP BY

    tfifield (2/16/2011)

    eh936 (2/15/2011)

    tfifield (2/15/2011)

    Thanks for letting me know. I thought your requirement was to list the actual orders for those customers. Of course your query works fine and...

    February 16, 2011 at 1:08 pm

    #1287897

  • RE: Northwind Querry INNER JOIN GROUP BY

    tfifield (2/15/2011)

    Thanks for letting me know. I thought your requirement was to list the actual orders for those customers. Of course your query works fine and is very...

    February 15, 2011 at 1:23 pm

    #1287289

  • RE: Northwind Querry INNER JOIN GROUP BY

    tfifield (2/15/2011)

    It probably gave you an ambiguous column name error since I forgot to specify a table alias in the join in the CTE.

    INNER JOIN Customers C ON

    ...

    February 15, 2011 at 12:07 pm

    #1287253

  • RE: Northwind Querry INNER JOIN GROUP BY

    tfifield (2/14/2011)

    eh936,

    The only way I know of to get the order info from just customers with 15 or more orders is to first determine which customers have that many orders...

    February 14, 2011 at 1:53 pm

    #1286742

  • RE: Northwind Querry INNER JOIN GROUP BY

    Firstly thanks for the reply. Secondly after running the above code in SQL Serve 2005 it returns 678 rows. Does that sound correct ? The report should return 5 rows....

    February 13, 2011 at 4:14 pm

    #1286210

Viewing 6 posts - 1 through 7 (of 7 total)