recordset not updatable, here's SQL

  • Thread starter Thread starter ExcessAccess
  • Start date Start date
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*"));
 
Back
Top