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!
-
Congratulations Rhinorhino 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 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...
