![유니온쿼리(Union Query)이용 결과값(Result Value) 합치기(Sum)](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fbl4Vdy%2FbtrXt97mBTr%2FCVsIzhMlLg32DAbi2KHDA1%2Fimg.jpg)
# DataBase/Mysql(MariaDB)2023. 1. 30. 13:57유니온쿼리(Union Query)이용 결과값(Result Value) 합치기(Sum)
유니온쿼리를 이용해서 아래와 같이 2개의 결과값을 합쳐야할 경우 아래와 같이 하면됩니다. MariaDB [darksharavim]> SELECT count(*) as cnt FROM `wp_usermeta`; +-----+ | cnt | +-----+ | 41 | +-----+ 1 row in set (0.001 sec) MariaDB [darksharavim]> SELECT count(*) as cnt FROM `wp_postmeta`; +-----+ | cnt | +-----+ | 39 | +-----+ 1 row in set (0.001 sec) MariaDB [darksharavim]> select sum(cnt) from ( -> SELECT count(*) as cnt FROM `wp_user..