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.

[micheledenardi]

I think you have to add "Order Details" in the "From" section...

[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` , `Order Details`

WHERE `Orders`.`OrderID` = `Order Details`.`OrderID`;

[#3]

I've done wrong to copy my script, but there was Order Details table.

[micheledenardi]

Try to split your select:

OrderHeader:

SQL SELECT

  `Orders`.`OrderID`,

  `Orders`.`OrderDate`,

  `Orders`.`ShipCity`

FROM `Orders`;

left join(OrderHeader)

OrderItems:

SQL SELECT

`Order Details`.`OrderID`,

`Order Details`.`ProductID`,

    `Order Details`.`Discount`,

    `Order Details`.`Quantity`

FROM `Order Details`;

Does it work ?

[#5]

no, it doesn't work like that.

but where are sql queries?

[vishsaggi]

May be 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`,

LEFT JOIN

`Order Details`

ON `Orders`.`OrderID` = `Order Details`.`OrderID`;

[#7]

nope!

I've tried to put that code into a single section, after the ones that upload table from my db file, but doesn't work.

When i perform debugger it stops at SQL SELECT ... row.

[micheledenardi]

try to remove all the apex `

[#9]

nothing change

[vishsaggi]

I am sure you might be, just wondering to know if you are connecting to the database before loading using connection string.. Are you getting any results when you run only your SQL script on SQL editor?