作者hukhuk (ken)
看板Database
标题Re: [SQL ] NVL 相关疑难一问
时间Sat Mar 3 20:12:26 2012
SELECT if(car is null ,0,count(*)) as item_count ,carname as car
from tb left outer join ta on tb.carname = ta.car
group by carname;
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 219.87.129.115
1F：→ hukhuk:改成SELECT count(car) as item_count 这样好了 03/03 20:18
2F：推 kfei:感谢感谢 学到了一课 03/16 10:13