The syntax error is on the 2nd FROM?
There are 2 tables
1. location:location_cd, bu
2. cart_inventory: accountNo,zonenm,zoneid .sku, location_code
How do you tell it which table to get the fields from?
CREATE VIEW inventory_complete
AS SELECT location_cd, bu FROM cart_order.location
accountNo, zonenm,zoneid,sku,
class,qty,unit,cost,extCost,location_code
FROM cart_order.cart_inventory
WHERE location.location_cd = cart_inventory.location_code
thanks,
