"Syntax error, missing/misplaced FROM:

[#1]

Hi, I am going through the Course - Developer 1 Version 9 e-Learning: Currently, I am working on : Module 6- Synthetic Keys and circular references I am stuck up at the following code.. LOAD //CustomerID, //EmployeeID, //LineNo, // OrderID, autonumber(OrderID & '|' & LineNo) as Orderlinekey, // ProductID, ShipmentDate, // ShipperID; SQL SELECT * FROM Shipments; I am getting the following error. " "Syntax error, missing/misplaced FROM: LOAD autonumber(OrderID & '|' & LineNo) as Orderlinekey, ShipmentDate, SQL SELECT * FROM Shipments LOAD autonumber(OrderID & '|' & LineNo) as Orderlinekey, ShipmentDate, SQL SELECT * FROM Shipments" I can not solve this.. why I am not able to use the 😆 autonumber(OrderID & '|' & LineNo) as Orderlinekey, Please help

[#2]

Hey,

You should change
" ShipmentDate, " to " ShipmentDate; " as this is the last field to load before making the SELECT statement.

__
Jens

[#3]

Hi Jens, Yes!! this is working now.. Thanks a lot..