Ready to get started with anonymous questions today? It's easy! Learn more.
If <invoice number within AUTO_EFORM.SUBJECT> = ORDER_CONTACT.INVOICE_NO and ORDER_CONTACT.SO_CONTACT_ID is not blank then replace AUTO_EFORM.CONTACT_ID with ORDER_CONTACT.SO_CONTACT_ID
update auto_eform set contact_id = select order_contact_id from order_contact, auto_eform ae where substr(ae.subject, 10, (instr(ae.subject, ' ', 10)-10)) = order_contact.invoice_no
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.