日期:2014-05-17 浏览次数:20787 次
select pgdwgms.dwg_no, pgdwgms.dwg_rev, pgdwgms.isse_no
from pgdwgms, pgappref
where pgdwgms.acur_fg = '1'
and pgdwgms.status > '7'
and (PGAPPREF.upd_who = '0032' and PGAPPREF.table_no = '2' and
PGAPPREF.record_type = '1' and pgappref.seq_no = pgdwgms.seq_no )
order by pgdwgms.dwg_no, pgdwgms.dwg_rev
select pgdwgms.dwg_no, pgdwgms.dwg_rev, pgdwgms.isse_no
from pgdwgms, pgappref, pgissetr
where pgdwgms.acur_fg = '1'
and pgdwgms.status > '7'
and ((instr(PGAPPREF.upd_who, '0') = 1 and table_no = '1' and
record_type = '4')
and pgappref.seq_no = pgissetr.seq_no
and pgissetr.isse_no = pgdwgms.isse_no)
order by pgdwgms.dwg_no, pgdwgms.dwg_rev
intersect
sql1
intersect
seql2
intersect
sql3
intersect
sql4
.....
select pgdwgms.dwg_no, pgdwgms.dwg_rev, pgdwgms.isse_no
from pgdwgms, pgappref
where pgdwgms.acur_fg = '1'
and pgdwgms.status > '7'
and ((条件一 and (PGAPPREF.upd_who = '0032' and PGAPPREF.table_no = '2' and
PGAPPREF.record_type = '1' and pgappref.seq_no = pgdwgms.seq_no )