Hello,

I've gone through the site tutorials and I have a basic understanding on how things are set up and used. I'm now ready to try explore Lianja on my own.
What would be the best way to create a page with a grid that displays data from several tables?

Using the Southwind database, here is the output I would be looking for (where | separates the columns):
Contact Name | Company Name | Order ID | Order Date | First Name | Last Name

- Contact name & company name comes from Customers table
- Use the customerid to link to Orders table to get the order id and order date
- Use the employeeid to link to Employees table to get the first and last name.

An sql statement might look similar to:
Code:
SELECT Customers.contactname, Customers.companyname, Orders.orderid, Orders.orderdate, Employees.firstname, Employees.lastname
FROM Customers
INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID
INNER JOIN Employees ON Orders.EmployeeID=Employees.EmployeeID
ORDER BY Customers.contactname;
Thanks,
Cory