select o.Option_text,COUNT(v.Option_ID)AS ALLCOUNT FROM Polls_Votes v left outer join Polls_Option o ON v.Option_ID=o.Option_ID WHERE v.Polls_ID='35' GROUP BY Option_ID 有列名不明确的错误, 而我写成 SELECT v.Option_ID ,COUNT(v.Option_ID)AS ALLCOUNT FROM Polls_Votes vwhere v.Polls_ID='35' GROUP BY Option_ID 却没有呢?可惜上面的才是我想要的接果
select o.Option_text,COUNT(v.Option_ID)AS ALLCOUNT FROM Polls_Votes v , Polls_Option o WHERE v.Option_ID=o.Option_ID and v.Polls_ID='35' GROUP BY o.Option_ID
Polls_Votes v left outer join Polls_Option o ON v.Option_ID=o.Option_ID WHERE v.Polls_ID='35' GROUP BY Option_ID
有列名不明确的错误,
而我写成
SELECT v.Option_ID ,COUNT(v.Option_ID)AS ALLCOUNT FROM Polls_Votes vwhere v.Polls_ID='35' GROUP BY Option_ID
却没有呢?可惜上面的才是我想要的接果
Polls_Votes v , Polls_Option o
WHERE v.Option_ID=o.Option_ID and v.Polls_ID='35' GROUP BY o.Option_ID