workflow error

I have created a module, and create a corresponding workflow, to send an email is certain fields have been marked.
Howver, the system do not send any email, and the log file error is inserted below - any advise, what to do?

LEFT JOIN nport_nport nport_nport_accounts ON AND nport_nport_accounts.deleted=0
LEFT JOIN nport_nport_cstm nport_nport_accounts_cstm ON = nport_nport_accounts_cstm.id_c WHERE nport_nport_accounts_cstm.simcard_sent_c = ‘1’ AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘753adf82-6ed6-bcab-1ba9-58e2ab80c31a’ AND AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND accounts.deleted = 0 : MySQL error 1054: Unknown column ‘’ in ‘on clause’

It looks like you are joining nport_nport_cstm, but your ON clause is using when it should be using nport_nport_cstm.id_c.

Thank you,

Any idea on how to fix it ?

Can you post a screen shot of your workflow settings?

ofcourse - happy to

attached screenshot