Want to Join Two Different WP Tables

  • I am running two WP blogs and I want to join WP_Users table with each other. I tried following MySQL Query in PhpmyAdmin but facing error #1052 – Column ‘user_login’ in field list is ambiguous

    Can anyone guide me how can I join WP_Users tables from two different WP with each other at same server, because I want single user login for both blogs

    SQL Query

    SELECT first_db.wp_users.ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name,
    second_db.wp_users.ID, c.user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name
    FROM first_db.wp_users LEFT JOIN second_db.wp_users
    ON
    (
    first_db.wp_users.ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name = second_db.wp_users.ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name
    );

Viewing 8 replies - 1 through 8 (of 8 total)
Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Want to Join Two Different WP Tables’ is closed to new replies.

Tags