2 : SELECT Photos_Category.Category, Photos_Galleries.GalleryName, Photos_Images.ImageTitle, Photos_Images.Filename, Photos_Images.ImageID, Photos_Images.ImageDescription, Photos_Galleries.GalleryDescription
3 : FROM (Photos_Galleries INNER JOIN Photos_Category ON Photos_Galleries.CategoryID = Photos_Category.CategoryID) LEFT JOIN Photos_Images ON Photos_Galleries.GalleryID = Photos_Images.GalleryID
4 : WHERE (((Photos_Galleries.GalleryID)=#url.galleryID#));
5 : </cfquery>
6 :
|