select sn,wo_no from IMPORT_RUNCARD_sn where wo_no='MO4506A013'

and 1=1

and sn not in (

select detail.sn from SMT_MULTIPANEL_header head, SMT_MULTIPANEL_DETAIL detail

where 1=1

and head.id=detail.MULT_HEADER_ID

and head.wo_no='${参数名}')

PS：参数名可以自定义

参考文档数据集参数： https://help.fanruan.com/finereport/doc-view-158.html

select sn, wo_no

  from IMPORT_RUNCARD_sn

 where wo_no = '${wo_no}'

   and 1 = 1      

   and sn not in (        

        select detail.sn

          from SMT_MULTIPANEL_header head, SMT_MULTIPANEL_DETAIL detail        

         where 1 = 1              

           and head.id = detail.MULT_HEADER_ID              

           and head.wo_no = '${wo_no}')

------------------------------------

wo_no为参数名

空间名需要与参数保存一致