17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT job.job_name 型号, job.surface_treat_ 表面处理, job.specified_core_vendor_ 板料供应商 FROM rpt_job_list job WHERE UPPER(job.customer_name_) LIKE '%VAL%'
SELECT en.value FROM field_enum_translate en WHERE en.intname='JOB' AND en.fldname='SURFACE_TREAT_' AND en.enum=1001
SELECT en.value FROM field_enum_translate en WHERE en.intname='JOB' AND en.fldname='SPECIFIED_CORE_VENDOR_' AND en.enum=1030