Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT mpcp.nlenr, dl16.last_edit_by, mpcp.mes_create_date, dl16.wo_id
- FROM data_log_16 dl16 WITH (NOLOCK)
- INNER JOIN mes_prod_conf_pubr mpcp WITH (NOLOCK) ON mpcp.pro_ord = dl16.wo_id AND mpcp.NLENR = (dl16.value10 + dl16.value11)
- WHERE mpcp.nlenr LIKE '35000144125%' AND mpcp.mes_create_date > (GETDATE() - 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement