SQL Error: Ambiguous column in WHERE clause

[Hiwo-1101000-1101001]

Description:

An SQL query fails due to an ambiguous column reference in the WHERE clause. The affected column exists in multiple joined tables, causing a conflict when the database engine tries to interpret the query.

Actual Behavior:

Query fails with the following error:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column '[column_name]' in where clause is ambiguous

Expected Behavior:

The query should execute without errors.

Steps to Reproduce:

1. Execute an SQL query that joins multiple tables containing the same column name.
2. Use this column in the WHERE clause without specifying the table.
3. The error occurs.

Possible Solution:

Explicitly specify the table in the WHERE clause, for example:

WHERE table_name.column_name IN (value)