topic Can we implement SQL queries as it is they were written in sql in QlikView

Can we implement SQL queries as it is they were written in sql

ferha_jafri — Wed, 29 Jan 2014 10:38:36 GMT

Hello everyone,

I am confused that whether we can execute below mentioned sql query as it is written in sql or not

SELECT Customers.FirstName, Customers.LastName, SUM(Sales.SaleAmount) AS

SalesPerCustomer FROM Customers

LEFT JOIN Sales ON Customers.CustomerID = Sales.CustomerID

GROUP BY Customers.FirstName, Customers.LastName;

SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date

FROM suppliers, orders WHERE suppliers.supplier_id = orders.supplier_id;

as i am getting error when i am writting the code as it is.

Thanks in advance

Ferha Jafri

Sokkorn — Wed, 29 Jan 2014 10:43:02 GMT

Hi Ferha,

Does it work in your SQL server or not? Are you got error in QlikView Script?

You may try

SQL SELECT Customers.FirstName, Customers.LastName, SUM(Sales.SaleAmount) AS

SalesPerCustomer FROM Customers

LEFT JOIN Sales ON Customers.CustomerID = Sales.CustomerID

GROUP BY Customers.FirstName, Customers.LastName;

SQL SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date

FROM suppliers, orders WHERE suppliers.supplier_id = orders.supplier_id;

Regards,

Sokkorn

ferha_jafri — Wed, 29 Jan 2014 10:59:40 GMT

LEFT JOIN Sales ON Customers.CustomerID = Sales.CustomerID

GROUP BY Customers.FirstName, Customers.LastName;

while executing this i am getting an error as unknown statement left join

Wed, 29 Jan 2014 11:14:55 GMT

Try like this

SQL

SELECT Customers.FirstName, Customers.LastName, SUM(Sales.SaleAmount) AS

SalesPerCustomer FROM Customers

LEFT JOIN Sales ON Customers.CustomerID = Sales.CustomerID

GROUP BY Customers.FirstName, Customers.LastName;

SQL

SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date

FROM suppliers, orders WHERE suppliers.supplier_id = orders.supplier_id;