craig Site Admin
Joined: 19 Feb 2006 Posts: 40
|
Posted: Tue Jul 25, 2006 6:31 am Post subject: select rows in table a that are not in table b |
|
|
select * from edw.price_quote_option_review_history H
where not exists (select * from edw.price_quote_option_review R
where h.edw_pq_id = r.edw_pq_id and h.db_cd = r.db_cd
and h.seq_cd = r.seq_cd and h.pq_dept_grp_cd = r.pq_dept_grp_cd and h.revu_in_ts = r.revu_in_ts) fetch first 100 rows only; |
|