Be seen. Boost your question’s priority for more expert views and faster solutions
SELECT I1.[IMAGE_NAME] Main_Image_Name,
I1.[IMAGE_DATA] Main_Image_Data,
I2.[IMAGE_NAME] Sub_Image_Name,
I2.[IMAGE_DATA] Sub_Image_Data
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I1
ON p.Product_Image = I.Image_ID
LEFT JOIN [Store].[dbo].[Images] I2
ON p.Product_Thumb = I.Image_ID
WHERE P.Product_ID = @Product_ID
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
SELECT [IMAGE_NAME],I1.[IMAGE_DAT
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I1 ON p.Product_Image = I1.Image_ID
LEFT JOIN [Store].[dbo].[Images] I2 ON p.Product_Thumb = I2.Image_ID
WHERE Product_ID = @Product_ID