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

[ferha_jafri]

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]

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]

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

[#4]

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;