11 Replies Latest reply: May 25, 2017 3:53 AM by Mauro Bellicini RSS

    Two table query doesn't work

    Mauro Bellicini

      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
      OrderDateProductID
      ShipCityDiscount
      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.