DataBase/SQL
[SQL/TABLE/COLUMN] 테이블의 성격에 따라 다른 컬럼값
-- 첫번째 쿼리. SELECT o.invoice_code FROM ORDER o INNER JOIN ORDER_USER bot ON o.id = bot.order_id LEFT JOIN BILLING_BOT_MAP map ON bot.name = map.bot_name LEFT JOIN BILLING b ON map.biling_id = b.id WHERE o.order_code = 'code123'; -- 두번째 쿼리. SELECT b.invoice_code FROM ORDER o INNER JOIN ORDER_USER bot ON o.id = bot.order_id LEFT JOIN BILLING_BOT_MAP map ON bot.name = map.bot_name LEFT JOIN BILLING ..
