create view myview1 as
select a.enterprise, aaa, bbb ,ccc from
(select distinct enterprise from finalresult) a left join
(select enterprise, result aaa from finalresult where chosentarget='aaa' group by enterprise) a1d on a.enterprise = a1d.enterprise
left join (select enterprise, result bbb from finalresult where chosentarget='bbb' group by enterprise) a2d on a2d.enterprise=a.enterprise
left join (select enterprise, result ccc from finalresult where chosentarget='ccc' group by enterprise) a3d on a3d.enterprise=a.enterprise另外:在输出的结果中怎么降“NULL”变成“0”,我知道用isnull(字段,0)方法,具体该怎么写,请大家帮一下啦,不胜感激~
select a.enterprise, aaa, bbb ,ccc from
(select distinct enterprise from finalresult) a left join
(select enterprise, result aaa from finalresult where chosentarget='aaa' group by enterprise) a1d on a.enterprise = a1d.enterprise
left join (select enterprise, result bbb from finalresult where chosentarget='bbb' group by enterprise) a2d on a2d.enterprise=a.enterprise
left join (select enterprise, result ccc from finalresult where chosentarget='ccc' group by enterprise) a3d on a3d.enterprise=a.enterprise另外:在输出的结果中怎么降“NULL”变成“0”,我知道用isnull(字段,0)方法,具体该怎么写,请大家帮一下啦,不胜感激~
mysql> SELECT IFNULL(1,0);
-> 1
mysql> SELECT IFNULL(NULL,10);
-> 10
mysql> SELECT IFNULL(1/0,10);
-> 10
mysql> SELECT IFNULL(1/0,'yes');
-> 'yes'
另外,那个将NUll变成0可不可以直接在sql语句中实现呢
另外你的mysql版本是多少?