Re: [SQL ] 請問查詢語法
DBMS ？
※ 引述《ckmarkhsu (深藍站長)》之銘言：
: 環境大概是這樣，我有兩個 Table
: TableA tableAID (主鍵)
: title
: ....etc
: TableB tableBID (主鍵)
: tableAID
: done
: TableA 與 TableB 是關聯式(唔這樣用詞對嗎?)，以 tableAID 做連結
: 一筆 TableA 的紀錄會有五筆 TableB 紀錄
: 我的查詢條件為，只有在 tableA 之所有 tableB done = 1 時，才列出
: 我的寫法是
: SELECT * FROM TableA
: LEFT JOIN TableB USING (tableAID)
: WHERE done = 1
: 但這樣似乎不對，請問應該如何寫才是正確的^^"
SELECT * FROM `TableB`
LEFT JOIN `TableA` ON `TableB`.`tableAID` = `TableA`.`tableAID`
WHERE `TableB`.`done` = '1'
--
Linux is for people who want to know why it works.
Mac is for people who don't want to know why it works.
DOS is for people who want to know why it does not work.
Windows is for people who don't want to know why it does not work.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.173.173.193
推
05/08 12:53, , 1F
05/08 12:53, 1F
推
05/08 12:59, , 2F
05/08 12:59, 2F
推
05/08 13:01, , 3F
05/08 13:01, 3F
推
05/08 13:10, , 4F
05/08 13:10, 4F
推
05/08 13:20, , 5F
05/08 13:20, 5F
→
05/08 14:12, , 6F
05/08 14:12, 6F
推
05/08 17:55, , 7F
05/08 17:55, 7F
討論串 (同標題文章)