Title: JOIN Query Not Working
Last modified: August 20, 2016

---

# JOIN Query Not Working

 *  [rkralston](https://wordpress.org/support/users/rkralston/)
 * (@rkralston)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/join-query-not-working/)
 * This works:
 *     ```
       $authors = $wpdb->get_results("
       SELECT DISTINCT u.ID, u.user_nicename
       FROM      $wpdb->users u JOIN $wpdb->posts p ON p.post_author = u.ID
       WHERE     (p.post_status = 'publish') AND (p.post_type = 'post')
       ORDER BY user_nicename
       ");
       ```
   
 * This does not:
 *     ```
       $authors = $wpdb->get_results("
       SELECT DISTINCT u.ID, u.user_nicename, um.meta_value AS last_name
       FROM $wpdb->users u JOIN $wpdb->posts p ON p.post_author = u.ID
       JOIN $wpdb->usermeta um ON (um.user_id=u.ID AND meta_key='last_name')
       WHERE (p.post_status = 'publish') AND (p.post_type = 'post')
       ORDER BY last_name
       ");
       ```
   
 * The second query works fine in SQL Manager.
 * Thanks for any tips.

The topic ‘JOIN Query Not Working’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [rkralston](https://wordpress.org/support/users/rkralston/)
 * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/join-query-not-working/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics