Help with a basic sql in DBISAM

Databases
1

Hi Folks
Trying to run the following in a DBISAM database, get error attached. Program3 is the heading in the field. If you need the data base please advise as I cannot get it to attach here.
newbe on this forum.

UPDATE Product
SET Product.ProductGroup = ProductDetail.Program3
FROM Product INNER JOIN ProductDetail ON ProductDetail.ProductCode = Product.ProductCode;
WHERE PG_description = ‘Unassigned’;

UPDATE Product
SET Product.StockUnit = StockUnit.StockUnit
FROM Product INNER JOIN StockUnit ON StockUnit.ProductGroup = Product.ProductGroup
WHERE SU_Description = ‘Unit’;

2

didn’t see your actual error message, but there’s a semicolon before your WHERE clause in the first statement

3
4

Thanks but that did not help will try and attach error again. Ok think it worked that time it is a *.gif