Any idea why this query always returns duplicate items?
- by Kardo
I want to get all Images not used by current ItemID. The this subquery but it also always returns duplicate Images:
EDITED
select Images.ImageID, Images.ItemStatus, Images.UserName, Images.Url,
Image_Item.ItemID, Image_Item.ItemID
from Images
left join (select ImageID, ItemID, MAX(DateCreated) x
from…
