Search

7-5. Check Quiz

-- [CQ-7-5-4] EXPLAIN (COSTS OFF) SELECT /*+ */ t1.* ,t2.* , t3.* FROM startdbpg.tr_ord t1 INNER JOIN startdbpg.tr_ord_det t2 ON (t1.ord_no = t2.ord_no) INNER JOIN startdbpg.ms_item t3 ON (t3.item_id = t2.item_id) WHERE t1.ord_no BETWEEN 10 AND 30 AND t2.ord_no BETWEEN 10 AND 30;
SQL
복사