Relational Database Example using Jquery Easyui

[neil]

Hi All, Please can anyone show example using joins in relational database. Example: Customers have many order.

[reems]

Hi Neil,

Something like this:

SELECT table.customers_name, table_orders.customerid, table_orders.amount, etc for other fields
FROM table_customers
LEFT JOIN table_orders
ON table_orders.customerid = table_customers.id
WHERE table_customers.id = ?

Allthough you should af course just have googled an example:
http://www.mysqltutorial.org/mysql-left-join.aspx   (here even an example indeed with customers and orders)

Next time maybe just Jeasyui questions here?

Reems