[oracle] 4개 테이블 조인 참고

select 
    mi.MB_NAME, 
    mi.MB.TEL, 
    mi.MB_PHONE, 
    gi.GS_NAME, 
    gi.GS_IMG, 
    oi.*, 
    od.* 
from 
    order_detail od, 
    order_info oi, 
    member_info mi, 
    goods_info gi 
where 
    od.oi_no = oi.oi_no and 
    oi.mb_no = mi.mb_no and 
    od.gs_code = gi.gs_code and 
    od.oi_no = 1