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 = ...