There is an ambiguous where clause for column 'status'

Question

cursor.execute("SELECT*FROM`xplt_cases`LEFTJOIN`dgn_cases`ONdgn_cases.rid=xplt_cases.ridWHERE`status`=%(checker)s",{'checker':status}) I am new to MySQL and I am trying to combine two tables are joined together to get the results, but I get an error message: Column status in where clause is not

P粉066224086 · Answer

Hmm, it looks like both of your tables have a status column. Try prefixing it with the table name (alias):

SELECT * FROM `xplt_cases` x LEFT JOIN `dgn_cases` ON dgn_cases.rid = xplt_cases.rid
WHERE x.`status`=%(checker)s

P粉850680329 · Answer

ErrorColumn 'status' in where clause is ambiguous means that the 2 tables you joined in the query have a column named status, which is Why Mysql tells you that column status is ambiguous

You can solve this problem by indicating which status column in the table to use in the query. Example;

xplt_cases.`status`=%(checker)s"

or

dgn_cases.`status`=%(checker)s"