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 IamaSherpa 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: *

  1. jamiehook01

    Displaying all results but filtered

    Thank you that worked great!!! sorry about the wrong forum :)
  2. jamiehook01

    Displaying all results but filtered

    Thank you for your response, i now get the error Join expression not supported. i have tried left and right join
  3. jamiehook01

    Displaying all results but filtered

    Hi i am trying to display all records but only the rating from a curently logged in user (asp.net) but with my statement as it currently is it only returns records that the user has rated! can any one help? rs.Open("SELECT * FROM [Photo] Photo LEFT JOIN [Rating] Rating ON Photo.PhotoID =...
  4. jamiehook01

    Problem Query return and average value

    Sorry i was being stupid, that was exactly what i wanted. Thank you very much :)
  5. jamiehook01

    Problem Query return and average value

    I want an average for the rating it is the rating field in the rating table
  6. jamiehook01

    Problem Query return and average value

    Hi i am trying to write a query which will return and average value for a rating (online photograph album with rating feature) here is what i have done so far rs.Open("SELECT Photo.PhotoID, Photo.Title, Rating.PhotoNO, Rating.Rating, Photo.url FROM [Photo] RIGHT JOIN [Rating] ON...

Part and Inventory Search

Back
Top