php - WHERE 关键字在内部联接中不起作用

Question

我用过WHERE user_contact_info.master_admin = 1但$users_list1它不起作用。我也用过AND user_contact_info.master_admin = 1，但它不起作用。$users_list2无需内部连接即可工作。我该如何修复$users_list1sql？谢谢！

SQL 1

$users_list1 = $wpdb->get_results( "SELECT 
                user_contact_info.id, 
                user_contact_info.user_name, 
                user_contact_info.user_title, 
                user_contact_info.user_direct, 
                user_contact_info.user_mobile, 
                user_contact_info.user_mail_address, 
                user_contact_info.user_email, 
                user_contact_info.master_admin, 
                company_info.com_name
                FROM user_contact_info 
                INNER JOIN company_info 
                ON user_contact_info.user_company = company_info.id WHERE user_contact_info.master_admin = 1 
                ORDER BY company_info.com_name ASC 
                limit  $offset, $limit" );

SQL 2

$users_list2 = $wpdb->get_results( "SELECT * from user_contact_info WHERE master_admin = 1 ORDER BY user_name ASC limit  $offset, $limit" )

标签： phpmysqlsqlinner-join