User Profile

Collapse

Profile Sidebar

Collapse
Tomerz
Tomerz
Last Activity: Apr 15 '09, 04:52 PM
Joined: Apr 6 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tomerz
    replied to problem with joins and aggregate functions
    in SQL Server
    ok,
    i changed the query as follows:
    Code:
    SELECT     Recipes.Id, Recipes.RecipeName, Recipes.DateAdded, Recipes.Show, Recipes.Category, Recipes.ShortDescription, Recipes.PrepareTime_Secs, 
                      Recipes.Level, RegisteredUsers.Username AS Uploader, AVG(Rate.Rating) AS r1, SUM(Rate.Rating) AS r2
FROM         Recipes INNER JOIN
                      RegisteredUsers ON Recipes.Uploader = RegisteredUsers.Id
    ...
    See more | Go to post

      Leave a comment:

    • Tomerz
      started a topic problem with joins and aggregate functions
      in SQL Server

      problem with joins and aggregate functions

      Hi all, and thanks ahead to the helpers.
      for several hours im trying to overcome on an error im stuck with..
      that's the issue:
      i have 3 table:
      1. Recipes
      2. RegisteredUsers
      3. RecipeRating

      the searching value would be Recipes.RecipeN ame.
      i would like to retrieve the following:
      1. Recipes.*
      2. RegisteredUsers .Username
      3. AVG(Rating) , SUM(Rating)

      that's...
      See more | Go to post
      No activity results to display
      Show More
      Working...