¾È³çÇϼ¼¿ä.
Àú SQL Äõ¸®Á» µµ¿ÍÁÖ¼¼¿ä..
SELECT UserID FROM (SELECT UserID From User WHERE Allowing ='Y') AS u LEFT JOIN Group AS g ON u.UserID != First_SenderID OR u.UserID != First_ReceiverID
¹¹ ÀÌ·±½ÄÀ¸·Î Çߴµ¥, ¿øÇÏ´Â °ªÀÌ Á¦´ë·Î ¾È³ª¿Í¼ Èì
Àß ¸ð¸£°Ú½À´Ï´Ù.
µµ¿ÍÁֽʼî! |
where a.allowing = 'Y'
and a.userid not in (
select b.first_senderid from group b)
and a.userid not in (
select b.first_receiverid from group b)
and a.userid not in (
select b.next from group b)
ÀÌ·¸°Ô ÇÏ´Ï ÀÏ´ÜÀº ³ª¿À´Âµ¥ ǮŽ»öÇÏ°Ô µÇ´Ï ¼Óµµ´Â º¸Àå ¸øÇÕ´Ï´Ù. ±×·ìÀ¸·Î Àß ¹°í Á¶°ÇÀ» ´õ Á༠¿µ¿ªÀ» ÁÙÀÌ´Â°Ô ÁÁÀ»°Å°°½À´Ï´Ù.
(¹» ¿øÇÏ´Â Áú¹®ÀÎÁö ÆÇ´ÜÀÌ ¾ÈµË´Ï´Ù.)