7 Replies Latest reply: Jan 31, 2016 2:01 PM by Massimo Grossi RSS

    Why doesn't multple SQL Joins script work in QlikView? Even though it works in standard SQL engine

    John Blomqvist

      Hi,

       

      I have the following SQL query. This works when I run it in a standard SQL query engine (e.g. SQL Server etc)

       

      But it doesn't work in QlikView. Is there a problem with QlikView when it comes to using multiple joins?

       

      One SQL join works but as soon as I do multiple joins it doesn't.

       

      I have ensured the field names are correct and table names are correct so this is not the issue.

       

      SELECT

      OrderID,

      Orders.CustomerID,

      CustomerName,

      Orders.EmployeeID,

      FirstName,

      LastName,

      OrderDate

      FROM

      Orders

      INNER JOIN

      [Customers]

      ON

      Orders.CustomerID = Customers.CustomerID

      Inner JOIN

      Employees

      ON

      Orders.EmployeeID = Employees.EmployeeID