sql queyr left join or

sql queyr left join or

더시민 0 89 0

select a.* , b.B1, b.B2, b.B3 , b.B4 as B44 , b.B5 as B55 from 테이블1번 a
                left join 테이블2번 b
                on (a.A = b.B1 and b.3 like '2022-11-27%' and b.2 = 'KKKKK' and b.4 = '444')
                and adatetime > now()
                and now() > DATE_ADD(cdatetime, interval 600 SECOND) 
                and (
                    (eng = 'thecitizne' and scnt <= '1500')
                    OR
                    (eng = 'thecitizeneng' and scnt <='3000')
                )
                and b.B3 is NULL
            order by cdatetime asc  limit 0, 1

0 Comments
제목
Category
Facebook Twitter GooglePlus KakaoStory KakaoTalk NaverBand