SELECT * FROM USER A
INNER JOIN USER_DETAIL B
ON A.USER_ID = B.USER_ID
AND DATEDIFF(NOW(), IFNULL(A.LOGIN_DATE, A.CREATED_DATE)) > 365
À§¿Í °°Àº Äõ¸®¹®ÀÌ Çϳª ÀÖ´Ù°í ÇßÀ»¶§,
Á¶ÀÎ AND Á¶°Ç¿¡ º¸¸é LOGIN_DATE°¡ null À̸é CATEDATED_DATE °ªÀ» ´ëüÇؼ ¿À´Ã³¯Â¥¶û ºñ±³ÇÏ´Â ºÎºÐÀÌ Àִµ¥,
À§¿Í °°ÀÌ ÇϳªÀÇ Äõ¸®·Î ÀÛ¼º µÈ °Í°ú
SELECT * FROM USER A
INNER JOIN USER_DETAIL B
ON A.USER_ID = B.USER_ID
AND A.A.LOGIN_DATE IS NULL
AND DATEDIFF(NOW(), A.CREATED_DATE) > 365
UNION ALL
SELECT * FROM USER A
INNER JOIN USER_DETAIL B
ON A.USER_ID = B.USER_ID
AND DATEDIFF(NOW(), A.LOGIN_DATE) > 365
À§¿¡ UNINON ALL À» °É¾úÀ»¶§ÀÇ Â÷À̸¦ ¾Ë°í ½Í½À´Ï´Ù.
¾î´ÀÂÊÀÌ ´õ ÁÁ´Ù´ø°¡, ¼Óµµ´Â ¾î´ÀÂÊÀÌ ´õ ³´´Ùµç°¡ ÀÌ·¸°Ô ÇؾßÇÏ´Â ÀÌÀ¯¶ó´ø°¡..
´ã´çÀÚ ¸»·Î´Â Äõ¸®¸¦ ºÐ¸®Çؼ uninon all ·Î 2°¡Áö Á¶°ÇÀ» °¢°¢ ÀÛ¼ºÇØÁÖ´Â°Ô ÁÁ´Ù´Âµ¥ ¿Ö±×·±Áö..
(¹°·Ð ÇØ´ç ´ã´çÀÚÇÑÅ× ¹°¾îº¸´Â°Ô Á¦ÀÏ ºü¸£±ä ÇÏ°ÚÁö¸¸ ±×ºÐÀÌ Á¤´äÀÎÁö´Â ¸ð¸£´Ï±î¿ä)
Áú¹® | 2471¸íÀÌ Àоú¾î¿ä. 18.119.124.65