select
*
from
zmaterialreceivecheck
where
productlotnumber = '091111H720'
select
s.orderno,
e.fullname
from
zmaterialsend s,
employee e
where
productlotnumber = '091111H720' and
s.employeeid = e.employeeid
select
o.orderno,
e.employeename,
e.fullname
from
zmaterialorder o,
employee e
where
orderno = 'REQ2009111000008' and
o.employeeid = e.employeeid