When I try this sql statement to execute
update claim cl set search_field = (select concat(cl.claim_description,' ', cl.legal_basis,' ',co.name) from contact co where cl.probable=1 and cl.search_field is null and co.id=cl.contact_id)
I get error above, and there is no column named descr. There is column named claim_description but it isn't descr
Does anyone have hint? Thank you
Aucun commentaire:
Enregistrer un commentaire