|
+----------+--------------+--------------+------------+-----------+
| lastWord | lastCOmwhal1 | lastComwhal2 | lastCheori | lastSamoo
|
+----------+--------------+--------------+------------+-----------+
| 8 | 0 | 0 | 0 | 0
|
| 0 | 0 | 8 | 0 | 0
|
| 0 | 0 | 0 | 24 | 0
|
+----------+--------------+--------------+------------+-----------+
Query : SELECT if(a.jmcd='BAAA',hakjum,0) as lastWord,
if(a.jmcd='BBAA',hakjum,0) as
lastCOmwhal1,if(a.jmcd='ABBA',hakjum,0) as
lastComwhal2,if(a.jmcd='ACEA',hakjum,0) as lastCheori,
if(a.jmcd='BBEA',hakjum,0) as lastSamoo FROM tjk04 a , jm_code b
WHERE a.jmcd=b.jm_code AND a.hakbun='200312073' and b.hakjum is not
null
저위에 값중에서 0값을 모조리 없애서
+----------+--------------+--------------+------------+-----------+
| lastWord | lastCOmwhal1 | lastComwhal2 | lastCheori | lastSamoo
|
+----------+--------------+--------------+------------+-----------+
|8 | | 8
|24 | | <--
이런식으로 뿌리게 하려면 어떻게 해야하나요..
+----------+--------------+--------------+------------+-----------+
|
