34,594
社区成员
发帖
与我相关
我的任务
分享
select
c.name_check_state,
a.no_bill,
from
ls_requisition_2 as b
left join
ls_requisition_1 as a on a.no_bill = b.no_body
left join
ls_item as c on c.no_ls = b.no_item;
select
c.name_check_state,
a.no_bill,
from
ls_requisition_2 as b
left join
ls_requisition_1 as a on b.no_body = a.no_bill
left join
ls_item as c on b.no_item = c.no_ls;