注意：以下資訊僅出于教育目的而人為創建。
以下查詢：
SELECT * FROM dapp.credentials WHERE id = ( SELECT MAX(id) FROM dapp.credentials )
獲取以下行：
| id | email | password | first_name | member_type | validated |
---------------------------------------------------------------------------------
| 5000|perkins@drit.com|1234perkins |Mickey | regular |1 |
現在這個另一個查詢：
SELECT cellphone, address, zipcode FROM dapp.members
WHERE user_id = ( SELECT MAX(user_id) FROM dapp.members )
得到這一行：
| cellphone | address | zipcode |
-------------------------------------------------
| (787)-142-6952|4108 Wheeler Ridge Dr|99563 |
那么，如何創建一個獲取這樣一行的查詢呢？
| id | email | password | first_name | member_type | validated || cellphone | address | zipcode |
----------------------------------------------------------------------------------------------------------------------------------
| 5000|perkins@drit.com|1234perkins |Mickey | regular |1 || (787)-142-6952|4108 Wheeler Ridge Dr|99563 |
我試過這個查詢：
SELECT * FROM dapp.credentials WHERE id = ( SELECT MAX(id) FROM dapp.credentials )
JOIN
(SELECT cellphone, address, zipcode FROM dapp.members
WHERE user_id = ( SELECT MAX(user_id) FROM dapp.members ))
但我得到了這個錯誤：
SQL 錯誤 [1064] [42000]：您的 SQL 語法有錯誤；檢查與您的 MySQL 服務器版本相對應的手冊，以在第 2 行的 'JOIN (SELECT cellphone, address, zipcode FROM dapp.members WHERE user_id = ( S' ) 附近使用正確的語法
我可以知道我上次查詢做錯了什么嗎？
uj5u.com熱心網友回復：
您可以CROSS連接 2 個查詢：
SELECT t1.*, t2.*
FROM (
SELECT *
FROM dapp.credentials
WHERE id = (SELECT MAX(id) FROM dapp.credentials)
) t1 CROSS JOIN (
SELECT cellphone, address, zipcode
FROM dapp.members
WHERE user_id = (SELECT MAX(user_id) FROM dapp.members)
) t2;
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/438121.html
上一篇：我很難在一個查詢中添加這兩個查詢