10
- Classic Style
- Zine Style
- Gallery Style
- Studio Style
- Blog Style
SELECT
IFNULL(castle,'없음') AS castle
, IFNULL(house,'없음') AS house
FROM(
SELECT
(SELECT name FROM castle WHERE castle_id = hascastle) AS castle
, CONCAT(
(SELECT house_name FROM house WHERE house_id = hashouse)
, ' 크기 : '
, CAST((SELECT house_area FROM house WHERE house_id = hashouse) AS CHAR)
) AS house
FROM CLAN_DATA
) T1
문자 접합할땐 CONCAT 을 사용하면되고
접할할문자 타입이 달라서 캐스팅을 해주고 접합해줬다...
이런부분은 좀 불편한 mysql
'헬로마켓'과 함께하는 스마트한 중고 아이템 거래
1
Copyright . All rights reserved. @XE