title: MySQL: "Column 'column_name' in where clause is ambiguous"
body: <p>I JOIN 2 tables </p>
  
  <p>for example</p>
  
  <pre>
  table_A
  +---------+-----------+-----------+
  | user_id | ticket_id | user_name |
  +---------+-----------+-----------+
  
  table_B
  +-----------+-------------+
  | ticket_id | ticket_name |
  +-----------+-------------+
  </pre>
  
  <p>If I run the following query:</p>
  
  <pre>
  SELECT
    table_A.user_id
  , table_A.user_name
  , table_B.ticket_name
  FROM table_A
  LEFT JOIN table_B ON table_B.ticket_id = table_A.ticket_id
  WHERE ticket_id = '1';
  </pre>
  
  <p>On the live server we get the error: "<code>Column 'ticket_id' in where clause is ambiguous</code>"<br>
  On the the test server the query is accepted.</p>
  
  <p><em>I know how to solve the error, that's not the problem.</em></p>
  
  <p>I would however be very happy if our test server would NOT accept this query and (just like the production server) throw an error.</p>
  
  <p>Does anybody know if there is some kind of setting that would make the test server throw an error just like the live server?</p>
  
  <p>P.S.<br>
  MySQL version on <em>Test server</em>: <code>5.0.32-Debian_7etch5-log</code><br>
  MySQL version on <em>Live server</em>: <code>5.0.41-community-log</code>  </p>