Details
Description
The resolution order should be closest to furthest.
select * from orders
where pid in (select value pid from parts);
means
select * from orders o
where o.pid in (select value p.pid from parts p);