Query with Join On not working

  • Resolved stevedtx99

    (@stevedtx99)


    9 years ago

    When I run the following query in SQL it runs fine, but when run in EZ SQl Reports, it is giving some type of Vector results:

    SELECT
    u1.*,
    m1.meta_value AS firstname,
    m2.meta_value AS lastname,
    FROM wp_users u1
    JOIN wp_usermeta m1 ON (m1.user_id = u1.id AND m1.meta_key = ‘first_name’)
    JOIN wp_usermeta m2 ON (m2.user_id = u1.id AND m2.meta_key = ‘last_name’)

Viewing 1 replies (of 1 total)
  • Thread Starter stevedtx99

    (@stevedtx99)

    9 years ago

    Disregard….just read other post (from mikerayjones) with white-space formatting issue of first 7 charaacters needing to be select (followed by a space).
    Mosified my SQL, and now it’s working.

Viewing 1 replies (of 1 total)

The topic ‘Query with Join On not working’ is closed to new replies.