Brug af DISTINCT i MS SQL - problemer!
Hvordan bruger jeg DISTINCT i denne sætning?Hvis et billede ID hører til flere kategorier vil billedet fremgå flere gange i resultatet hvilket skal undgås.
TABELSTRUKTUR:
image [table] - primary
image_id
mm....
imagecategories [tabel]
imagecat_id - primary
image_id
cat_id
categories [tabel]
cat_id - primary
mm...
SQL QUERY:
SELECT
image.image_id AS ID,
image_title AS ImageTitle,
image_description AS Description,
image_keywords AS Keywords,
categories.cat_id AS CategoriID,
cat_name AS CategoriName,
imagedata_size AS ImageSize,
imagedata_width AS ImageWidth,
imagedata_height AS ImageHeight
FROM image
INNER JOIN imagecategories ON imagecategories.image_id = image.image_id
INNER JOIN categories ON categories.cat_id = imagecategories.cat_id
INNER JOIN imagedata ON imagedata.image_id = image.image_id
WHERE
(imagedata_isthumbnail = 0 AND image_title LIKE '%storm%') OR
(imagedata_isthumbnail = 0 AND image_description LIKE '%storm%')
OR
(imagedata_isthumbnail = 0 AND image_keywords LIKE '%storm%')
Skriv gerne hvis spøgsmålet skal uddybes
