PHP-关联式JOIN好几个资料表笔记记录

说明

$sql = 'SELECT * FROM((资料表1 INNER JOIN 资料表2 ON 资料表1栏位=资料表2栏位) INNER JOIN 资料表3 ON 资料表1栏位=资料表3栏位)INNER JOIN 资料表4 ON 资料表1栏位=资料表4栏位 ORDER BY product.id ASC';

实战

$sql = 'SELECT * FROM((product INNER JOIN customer_data ON customer_data_id=customer_data.id) INNER JOIN Map_data ON product.customer_data_id=Map_data.customer_data_id)INNER JOIN shopping_list_status ON product.id=product_id ORDER BY product.id ASC';