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: cjlebel
  • Order by date
  1. cjlebel

    Join to add a column with a count from another table?

    Your original statement should work fine, with a few minor tweaks (you forgot an "s" and "A.AlbumDescA.," SELECT A.AlbumDesc,DateCreated,A.UserId, A.IsPrivate,A.CoverImgSrc,A.AlbumName, (SELECT COUNT(Id) FROM images B WHERE B.album_Id = A.album_Id) AS ImageCount FROM...

Part and Inventory Search

Back
Top