oracle四表結合怎麼查？（兩條線）

標籤：item   last   show   分享   com   sele   creat   origin   recycle   

一條線是item，para_value，feature；另外一條是 item，sku。

思考過程：先把item和sku表聯合查出結果集，然後再把這個結果集當成一張表，最後與另外兩張表結合查詢。

select *
from (select min(es.sku_price) sku_price, ei.*
from eb_item ei, eb_sku es
where ei.item_id = es.item_id
and ei.audit_status = 1
and ei.show_status = 0
group by ei.ITEM_ID,
ei.ITEM_NAME,
ei.ITEM_NO,
ei.BRAND_ID,
ei.CAT_ID,
ei.TAG_IMG_ID,
ei.TAG_IMG,
ei.IS_NEW,
ei.IS_GOOD,
ei.IS_HOT,
ei.PROMOTION,
ei.AUDIT_STATUS,
ei.SHOW_STATUS,
ei.IMGS,
ei.KEYWORDS,
ei.PAGE_DESC,
ei.ITEM_RECYCLE,
ei.ON_SALE_TIME,
ei.CHECK_TIME,
ei.UPDATE_TIME,
ei.UPDATE_USER_ID,
ei.CREATE_TIME,
ei.CHECKER_USER_ID,
ei.FULL_PATH_DEPLOY,
ei.FULL_PATH_DEPLOY_OFFER,
ei.ORIGINAL_ITEM_ID,
ei.LAST_STATUS,
ei.MERCHANT_ID,
ei.ITEM_SORT,
ei.SALES,
ei.CREATE_USER_ID,
ei.SIM_LEVEL,
ei.GIFT_DESC,
ei.GIFT_IMG,
ei.GIFT_SHOW_TYPE,
ei.IMG_SIZE1) e1,
eb_para_value ev,
eb_feature ef
where e1.item_id = ev.item_id
and ev.feature_id = ef.feature_id
and ef.is_select = 1

oracle四表結合怎麼查？（兩條線）