[SQL ] 求助這個SQL的語法

看板Database作者 (O2)時間13年前 (2012/04/12 23:00), 編輯推噓2(2推 0噓 10→)
留言12則, 4人參與, 最新討論串1/1
研究很久還是想不透怎麼轉換出來 希望有大大能幫忙解一下 小弟感激不敬>< http://ppt.cc/TzyI -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 111.184.255.118
推
04/12 23:05, , 1F
use join~
04/12 23:05, 1F
→
04/12 23:08, , 2F
樓上大大 小弟比較有問題的是 at last one 那部分
04/12 23:08, 2F
推
04/14 17:44, , 3F
select S.SNAME
04/14 17:44, 3F
→
04/14 17:44, , 4F
from SP NATURAL JOIN P NATURAL join S
04/14 17:44, 4F
→
04/14 17:45, , 5F
where P.COLOR='Blue'
04/14 17:45, 5F
→
04/14 17:45, , 6F
group by SP.S#
04/14 17:45, 6F
→
04/14 17:45, , 7F
having count(*)>=1;
04/14 17:45, 7F
→
04/17 23:36, , 8F
at least one 難道不是問你至少要有提供一個blue嗎?
04/17 23:36, 8F
→
04/17 23:37, , 9F
select S,P,SP
04/17 23:37, 9F
→
04/17 23:38, , 10F
上面打錯 select s.SNAME from S,P,SP
04/17 23:38, 10F
→
04/17 23:40, , 11F
from S,P,SP where S.S# = SP.S# and SP.P#=P.P#
04/17 23:40, 11F
→
04/17 23:41, , 12F
and P.color = 'blue';
04/17 23:41, 12F
‣ 更多 o2piexl 的文章
文章代碼(AID): #1FXkuBDv (Database)