Hi,
what is wrong with my query:
i am getting info "Coould not delete from specific table".
query designer:
This is happening when i am joining more than 11 fields.
If i am joining 10 fields - all is working fine.
why this is happening?
Please help,
Jacek
what is wrong with my query:
Code:
DELETE DISTINCTROW tblImages.*
FROM tblImages LEFT JOIN Temp_Images ON (tblImages.OSDistro = Temp_Images.OSDistro) AND (tblImages.Offer = Temp_Images.Offer) AND (tblImages.Sku = Temp_Images.SKU) AND (tblImages.Version = Temp_Images.Version) AND (tblImages.Urn = Temp_Images.Urn) AND (tblImages.OS = Temp_Images.OS) AND (tblImages.SystemNameFull = Temp_Images.SystemNameFull) AND (tblImages.ImageID = Temp_Images.ImageID) AND (tblImages.PlatformRepository = Temp_Images.PlatformRepository) AND (tblImages.Origin = Temp_Images.Origin) AND (tblImages.OSVersion = Temp_Images.OSVersion);
i am getting info "Coould not delete from specific table".
query designer:
This is happening when i am joining more than 11 fields.
If i am joining 10 fields - all is working fine.
Code:
DELETE DISTINCTROW tblImages.*
FROM tblImages LEFT JOIN Temp_Images ON (tblImages.OSVersion = Temp_Images.OSVersion) AND (tblImages.Origin = Temp_Images.Origin) AND (tblImages.PlatformRepository = Temp_Images.PlatformRepository) AND (tblImages.ImageID = Temp_Images.ImageID) AND (tblImages.SystemNameFull = Temp_Images.SystemNameFull) AND (tblImages.OS = Temp_Images.OS) AND (tblImages.Urn = Temp_Images.Urn) AND (tblImages.Version = Temp_Images.Version) AND (tblImages.Sku = Temp_Images.SKU) AND (tblImages.Offer = Temp_Images.Offer);
why this is happening?
Please help,
Jacek