mysql – Column ‘nome da coluna’ in where clause is ambiguous

Question:

I'm trying to assemble a left join where I want the results of a given 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 coming back is:

Column 'COD_IDENT_CLIEN' in where clause is ambiguous

Answer:

This error is very simple, the column COD_IDENT_CLIEN exists in both tables and therefore needs to be specified in the WHERE clause, so, put

WHERE CA.COD_IDENT_CLIEN = ...

or

WHERE C.COD_IDENT_CLIEN = ...

Scroll to Top