PHP-關聯式JOIN好幾個資料表筆記記錄

yan二手書店筆記記錄 php7

Ci_Yao_Yan 2019-09-27 08:50:36 ‧ 845 瀏覽

說明

$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';