E
ExcessAccess
My query is not updatable! Can anyone see why and/or have
a solution? Maybe I'm using the wrong joins...?
SELECT [ShopCartSmall - Misc].SKUID, [ShopCartSmall -
Desc].Name, [ShopCartSmall - Desc].Color, [ShopCartSmall -
Desc].[Terms 2], [ShopCartSmall - Desc].Desc,
[ShopCartSmall - Misc].Extended
FROM [ShopCartSmall - Price$] INNER JOIN ([ShopCartSmall -
Desc] INNER JOIN [ShopCartSmall - Misc] ON [ShopCartSmall -
Desc].SKUID = [ShopCartSmall - Misc].SKUID) ON
([ShopCartSmall - Price$].SKUID = [ShopCartSmall -
Misc].SKUID) AND ([ShopCartSmall - Price$].SKUID =
[ShopCartSmall - Desc].SKUID)
WHERE ((([ShopCartSmall - Desc].Name) Not
Like "*Discontinued*") AND (([ShopCartSmall - Desc].[Terms
2]) Like "*gemstone*" Or ([ShopCartSmall - Desc].[Terms
2]) Like "*quartzes*"));
a solution? Maybe I'm using the wrong joins...?
SELECT [ShopCartSmall - Misc].SKUID, [ShopCartSmall -
Desc].Name, [ShopCartSmall - Desc].Color, [ShopCartSmall -
Desc].[Terms 2], [ShopCartSmall - Desc].Desc,
[ShopCartSmall - Misc].Extended
FROM [ShopCartSmall - Price$] INNER JOIN ([ShopCartSmall -
Desc] INNER JOIN [ShopCartSmall - Misc] ON [ShopCartSmall -
Desc].SKUID = [ShopCartSmall - Misc].SKUID) ON
([ShopCartSmall - Price$].SKUID = [ShopCartSmall -
Misc].SKUID) AND ([ShopCartSmall - Price$].SKUID =
[ShopCartSmall - Desc].SKUID)
WHERE ((([ShopCartSmall - Desc].Name) Not
Like "*Discontinued*") AND (([ShopCartSmall - Desc].[Terms
2]) Like "*gemstone*" Or ([ShopCartSmall - Desc].[Terms
2]) Like "*quartzes*"));