I am trying to mount a left join
where I want the results of a certain code. My SQL is:
$resultado = mysql_query("SELECT CA.DAT_EHORA_EVENT, CA.TXT_NOMEX_EVENT, CA.MEM_DESCR_EVENT FROM tbl_CLIENTES C LEFT JOIN tbl_CLIENTES_AGENDA CA ON CA.COD_IDENT_CLIEN = C.COD_IDENT_CLIEN WHERE COD_IDENT_CLIEN = '".$COD_IDENT_CLIEN."'") or die(mysql_error());
The error that is returning is:
Column 'COD_IDENT_CLIEN' in where clause is ambiguous