Results 1 to 4 of 4
Thread: Help with a basic sql in DBISAM
Aug 12, 2013, 22:25 #1
- Join Date
- Aug 2013
- 0 Post(s)
- 0 Thread(s)
Help with a basic sql in DBISAM
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.
SET Product.ProductGroup = ProductDetail.Program3
FROM Product INNER JOIN ProductDetail ON ProductDetail.ProductCode = Product.ProductCode;
WHERE PG_description = 'Unassigned';
SET Product.StockUnit = StockUnit.StockUnit
FROM Product INNER JOIN StockUnit ON StockUnit.ProductGroup = Product.ProductGroup
WHERE SU_Description = 'Unit';