|
Title: Relational Database Example using Jquery Easyui Post by: neil on September 04, 2013, 12:06:29 AM Hi All, Please can anyone show example using joins in relational database. Example: Customers have many order.
Title: Re: Relational Database Example using Jquery Easyui Post by: reems on September 04, 2013, 08:07:31 AM 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 |