3个表
A(carton,pallet,idx) idx主键;
B(incoming_no,qa_no);
C( sn,idx);sn主键
B.incoming_no= A.carton or B.incoming_no=A.pallet现在输入sn 求qa_no
C表数据量较大, 日增量约1w, 查询时注意效率
A(carton,pallet,idx) idx主键;
B(incoming_no,qa_no);
C( sn,idx);sn主键
B.incoming_no= A.carton or B.incoming_no=A.pallet现在输入sn 求qa_no
C表数据量较大, 日增量约1w, 查询时注意效率
select b.qa_no
from B b,
A a,
C c
where c.sn = &enter_sn
and (b.incoming_no = a.carton
or b.incoming_no = a.pallet)
and c.idx = a.idx;
试试看吧~~