Be seen. Boost your question’s priority for more expert views and faster solutions
query - combine two into one dataset
I have to queries...The first shows a main image the second shows a thumb.. how could i combine these into one dataset? The thumb fields could get name with a thumb postfex
SELECT [IMAGE_NAME],[IMAGE_DATA]
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Image = I.Image_ID
WHERE Product_ID = @Product_ID
SELECT [IMAGE_NAME],[IMAGE_DATA]
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Thumb = I.Image_ID
WHERE Product_ID = @Product_ID
SELECT [IMAGE_NAME],[IMAGE_DATA]
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Image = I.Image_ID
WHERE Product_ID = @Product_ID
SELECT [IMAGE_NAME],[IMAGE_DATA]
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Thumb = I.Image_ID
WHERE Product_ID = @Product_ID
Asked:
-
2
- +1
1 Solution
SELECT [IMAGE_NAME],[IMAGE_DATA]
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Image = I.Image_ID
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Thumb = I.Image_ID
WHERE Product_ID = @Product_ID
FROM [Store].[dbo].[Products] P
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Image = I.Image_ID
LEFT JOIN [Store].[dbo].[Images] I ON p.Product_Thumb = I.Image_ID
WHERE Product_ID = @Product_ID
I have a thumb image AND a main image, Product_Image is the id for the main image and Product_Thumb is the image for the sub...
This dataset needs to show BOTH
So, i shoulid have 2 [IMAGE_NAME] AND [IMAGE_DATA] fielld one for the main and one for the thumb
This dataset needs to show BOTH
So, i shoulid have 2 [IMAGE_NAME] AND [IMAGE_DATA] fielld one for the main and one for the thumb
you mean this?
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
Question has a verified solution.
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.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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