Two table query doesn't work

[#1]

Hi everyone,

I'm trying to perform a query with two tables because i want to load a single table with more info.

I've theese two tables, already loaded in qlik from a  db file:

Orders	Order Details
OrderID	OrderID
OrderDate	ProductID
ShipCity	Discount
	Quantity

In script tag, I've done this:

[OrdersD]:
LOAD 
  [OrderID],
  [OrderDate],
  [ShipCity],
    [ProductID],
    [Discount],
    [Quantity];
SQL SELECT `Orders`.`OrderID`
  `Orders`.`OrderDate`,
  `Orders`.`ShipCity`,
  `Order Details`.`ProductID`,
    `Order Details`.`Discount`,
    `Order Details`.`Quantity`
FROM `Orders`
WHERE `Orders`.`OrderID` = `Order Details`.`OrderID`;

But when I perform debugger, it's only says "Connector reply error: ***"

What I've done wrong?

Thank you.

[#2]

i can't understand your question: I've created a OLE DB connection with a visual foxpro db, that had that two tables.

When i load single table with qlik, it works and script generated is lke this:

[Orders]:

LOAD

  [CustomerID],

  [EmployeeID],

  [Freight],

  [OrderDate],

  [OrderID],

  [RequiredDate],

  [ShipAddress],

  [ShipCity],

SQL SELECT `CustomerID`,

  `EmployeeID`,

  `Freight`,

  `OrderDate`,

  `OrderID`,

  `RequiredDate`,

  `ShipAddress`,

  `ShipCity`,

FROM `Orders`;

[Order Details]:

LOAD

  [Discount],

  [OrderID],

  [ProductID],

  [Quantity],

  [UnitPrice] AS [Order Details.UnitPrice];

SQL SELECT `Discount`,

  `OrderID`,

  `ProductID`,

  `Quantity`,

  `UnitPrice`

FROM `Order Details`;

But if i want to load my query as a new table, doesn't work!

[#3 · Accepted solution]

ok,

i fell very stupid: i notice just now that i've forgot a comma after

SQL SELECT `Orders`.`OrderID`

now it works!

sorry