---> select i.code, i.catalogLevel, i.MstrPkg_FileSize, i.MstrPkg_FileExt, i.MstrPkg_UploadDate, i.MstrPkg_ContentID, i.MstrPkg_Comment, 'Master Packaging' MstrPkg_Type, mstrpkg_img.imgpath mstrpkg_imgpath, mstrpkg_img.ImgName mstrpkg_imgname, mstrpkg_img.ImgExt mstrpkg_imgExt, i.UnitPkg_FileSize, i.UnitPkg_FileExt, i.UnitPkg_UploadDate, i.UnitPkg_ContentID, i.UnitPkg_Comment, 'Unit Packaging' UnitPkg_Type, unitpkg_img.imgpath unitpkg_imgpath, unitpkg_img.ImgName unitpkg_imgname, unitpkg_img.ImgExt unitpkg_imgExt, i.SubPkg_FileSize, i.SubPkg_FileExt, i.SubPkg_UploadDate, i.SubPkg_ContentID, i.SubPkg_Comment, 'Sub Unit Packaging' SubPkg_Type, subpkg_img.imgpath subpkg_imgpath, subpkg_img.ImgName subpkg_imgname, subpkg_img.ImgExt subpkg_imgExt, i.Img1_FileSize, i.Img1_FileExt, i.Img1_UploadDate, i.Img1_ContentID, i.Img1_Comment, 'Primary Image' Img1_Type, img1_img.imgpath img1_imgpath, img1_img.ImgName img1_imgname, img1_img.ImgExt img1_imgExt, i.Img2_FileSize, i.Img2_FileExt, i.Img2_UploadDate, i.Img2_ContentID, i.Img2_Comment, 'Secondary Image' Img2_Type, img2_img.imgpath img2_imgpath, img2_img.ImgName img2_imgname, img2_img.ImgExt img2_imgExt, i.Img3_FileSize, i.Img3_FileExt, i.Img3_UploadDate, i.Img3_ContentID, i.Img3_Comment, 'Tertiary Image' Img3_Type, Img3_img.imgpath Img3_imgpath, Img3_img.ImgName Img3_imgname, Img3_img.ImgExt Img3_imgExt, i.HiRes_FileSize, i.HiRes_FileExt, i.HiRes_UploadDate, i.HiRes_ContentID, i.HiRes_Comment, 'High Resolution' HiRes_Type, hires_img.imgpath hires_imgpath, hires_img.ImgName hires_imgname, hires_img.ImgExt hires_imgExt, i.HiResBS_FileSize, i.HiResBS_FileExt, i.HiResBS_UploadDate, i.HiResBS_ContentID, i.HiResBS_Comment, 'High Resolution' HiResBS_Type, HiResBS_img.imgpath HiResBS_imgpath, HiResBS_img.ImgName HiResBS_imgname, HiResBS_img.ImgExt HiResBS_imgExt, i.Img4_FileSize, i.Img4_FileExt, i.Img4_UploadDate, i.Img4_ContentID, i.Img4_Comment, 'Quaternary Image' Img4_Type, Img4_img.imgpath Img4_imgpath, Img4_img.ImgName Img4_imgname, Img4_img.ImgExt Img4_imgExt, i.Label_FileSize, i.Label_FileExt, i.Label_UploadDate, i.Label_ContentID, i.Label_Comment, 'Label Image' Label_Type, Label_img.imgpath Label_imgpath, Label_img.ImgName Label_imgname, Label_img.ImgExt Label_imgExt, i.OutOfPackage_FileSize, i.OutOfPackage_FileExt, i.OutOfPackage_UploadDate, i.OutOfPackage_ContentID, i.OutOfPackage_Comment, 'Out of Box Package' OutOfPackage_Type, OutOfPackage_img.imgpath OutOfPackage_imgpath, OutOfPackage_img.ImgName OutOfPackage_imgname, OutOfPackage_img.ImgExt OutOfPackage_imgExt from tbl_PRD_ProductImages i left outer join qry_ContentLookup mstrPkg_img on mstrPkg_img.contentId = i.MstrPkg_ContentID left outer join qry_ContentLookup UnitPkg_img on UnitPkg_img.contentId = i.UnitPkg_ContentID left outer join qry_ContentLookup SubPkg_img on SubPkg_img.contentId = i.SubPkg_ContentID left outer join qry_ContentLookup Img1_img on Img1_img.contentId = i.Img1_ContentID left outer join qry_ContentLookup Img2_img on Img2_img.contentId = i.Img2_ContentID left outer join qry_ContentLookup HiRes_img on HiRes_img.contentId = i.HiRes_ContentID left outer join qry_ContentLookup Img3_img on Img3_img.contentId = i.Img3_ContentID left outer join qry_ContentLookup Img4_img on Img4_img.contentId = i.Img4_ContentID left outer join qry_ContentLookup Label_img on Label_img.contentId = i.Label_ContentID left outer join qry_ContentLookup OutOfPackage_img on OutOfPackage_img.contentId = i.OutOfPackage_ContentID left outer join qry_ContentLookup HiResBS_img on HiResBS_img.contentId = i.HiResBS_ContentID where i.ownerId = 102 and i.fsl_tablecode = 'MFR'

#qry_getImages.code#