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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jamiehook01

  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...
See more

Part and Inventory Search

Back
Top