我很抱歉我的英語不好。我有一個項目注冊表：比如Type of service | Total Amount | prepayment | last payment | Cost of tolls web design | 1000 | 1 (F-key) | 2 (F-key) | 3 (F-key)付款狀態和金額的第二個表 id | amount | Payment status | Description 1 | 400 | yes | for prepayment 2 | 600 | no | for last payment 3 | 0 | no | for Cost of tolls 現在我的問題是：如何連接兩個表并取出所有三列？我已經用這段代碼取出了預付款欄SELECT mzmx_request.service, mzmx_request.amount,(mzmx_payment.payment) as prepayment,(mzmx_payment.status) as prepayment_status FROM mzmx_requestJOIN mzmx_payment ON mzmx_request.prepayment = mzmx_payment.id如何再添加兩列？JOIN mzmx_payment ON mzmx_request.payment = mzmx_payment.idJOIN mzmx_payment ON mzmx_request.pay_more = mzmx_payment.id
2 回答
墨色風雨
TA貢獻1853條經驗 獲得超6個贊
只需加入三次即可。你已經做過一次了。例如：
SELECT
r.service,
r.amount,
pp.payment as prepayment,
pp.status as prepayment_status,
lp.payment as last_payment,
lp.status as last_payment_status,
ct.payment as cost_of_tolls,
ct.status as cost_of_tolls_status
FROM mzmx_request r
left JOIN mzmx_payment pp ON r.prepayment = pp.id
left JOIN mzmx_payment lp ON r.lastpayment = lp.id
left JOIN mzmx_payment ct ON r.costoftolls = ct.id
由于您要針對同一張表加入三次，因此您需要為該表添加別名。在這種情況下，我使用別名pp、lp和ct分別表示預付款、最后付款和通行費。
喵喔喔
TA貢獻1735條經驗 獲得超5個贊
3 個引用字段是獨立的 - 因此它們需要獨立的引用表副本：
SELECT *
FROM main
JOIN slave AS slave1 ON main.prepayment = slave1.id
JOIN slave AS slave2 ON main.last_payment = slave2.id
JOIN slave AS slave3 ON main.cost_of_tolls = slave3.id
- 2 回答
- 0 關注
- 119 瀏覽
添加回答
舉報
0/150
提交
取消