Why is the request not being fulfilled?

Question

MySQL

$criteria->join = 'LEFT JOIN r_users ON r_users.email = r_payments.LABEL';

Returns error:
CDbCommand failed to execute SQL query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r_payments.label' in 'on clause' Please tell me
where the error might be. Table and column names are correct.

Answer 1

There is not much information, but I can assume that this should help

$criteria->join = 'LEFT JOIN r_users ON r_users.email = t.LABEL';

Answer 2

CDbCommand failed to execute SQL query: SQLSTATE[42S22]: Unknown field: 1054 Unknown column 'r_payments.label' in condition

Answer 3

There is no label column in the r_payments table