Pull MySQL data from multiple tables and merge into 1 PHP array

Apparently both wattp_users and wattp2_as_score tables have a column named score_as.

Put a prefix with the table name before every mention to score_as column, just as you did with the ID (e.g. wattp2_users.ID) to avoid beeing ambiguous.

Related Posts:

  1. Transaction when using WP functions rather than vanilla SQL?
  2. How to get the list of WooCommerce product image of a certain category from database?
  3. How to make WordPress plugin check for database changes and then do something?
  4. How to Join two tables from separate databases within WordPress
  5. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  6. register_activation_hook isn’t adding table to DB
  7. What SQL / WordPress queries would need a nonce?
  8. Importing Geo data into wordpress database
  9. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  10. $wpdb->insert() does not Insert record in a table
  11. Use $wpdb or other PHP script method to find/replace in WP database
  12. How can I add a new row in a separate database when someone registers via WordPress?
  13. Use variable in SQL statement
  14. mySQL queries are executed twice on wordpress website
  15. making php value numeric
  16. Database SQL query error
  17. How to run complex query using PHP
  18. Inserting other fields to existing registration form in a WordPress theme
  19. SQL Query Search page
  20. can’t delete a row from post_meta table
  21. Conditional statement within WP SQL query
  22. Undefined function mysql_connect()
  23. MySQL “Or” Condition
  24. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  25. How to auto login user again after change user_login
  26. Jquery ajax to custom php file: returning blank data
  27. Add value to usermeta without removing previous values?
  28. How can I call a row of user specific data from a custom table added to the WP Database
  29. How to merge local and live databases?
  30. Performance issues with large website [closed]
  31. Create a quick start wordpress installation [closed]
  32. theme options echoing multiple times
  33. WordPress 3 – how are passwords stored and how do I compare to them?
  34. how to echo all tables that start with a prefix
  35. How to select WooCommerce products by post_meta and order them
  36. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  37. Remove one value in dismissed_wp_pointers?
  38. Transferring working local PHP site to wordpress – with database (MySQL)
  39. Accessing data from a non-WP database/table within a page content
  40. Detect session/cookie variable in wordpress to prevent access to documents
  41. How can I save unique user data on my site? [closed]
  42. Ordering users by custom user meta
  43. Databases – Submitting data from inputs to database [closed]
  44. WordPress SQL injection
  45. multiple where condition in result query
  46. Grouping posts by a custom meta value
  47. Is it best to avoid using $wpdb for security issues?
  48. Should I use WordPress to skin a database website?
  49. WordPress Custom SQL Table with UserID Filter for results
  50. Correct PHP to output a single result of a Function with SQL Query
  51. I can’t update my data through $wpdb
  52. Output: “Array”
  53. How to use mysql LIKE with wpdb?
  54. Filter results from a serialized string to use on statistics
  55. Searching Posts Programmatically in a WordPress Plugin
  56. Using wordpress function to retrieve data
  57. Live search from database table
  58. Why my query does not run with prepare
  59. wpdb getting avatars and author url
  60. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  61. WordPress SQL JOIN query
  62. How to create Loop code for Menu using WordPress?
  63. How to WP_Query posts order by parent title?
  64. Convert a column of a table containing an Array as response in HTML
  65. get different meta-data of a complicated query at the same time
  66. Please help! I have a problem with getting wordpress databas
  67. Build A Custom SQL Query for WordPress Search
  68. Error establishing a database connection (Set-up locally)
  69. Storing huge number of users in wordpress
  70. Trying to create a shortcode to display categories with a specific product tag
  71. Creating multiple tables with Plugin
  72. Custom User registration system
  73. Can I split a huge wp_postmeta table across different databases or servers?
  74. how to get data from two different table from wordpress database
  75. Passing Current User ID into SQL statement
  76. How to insert multiple rows and columns in database using array
  77. Woocommerce – get daily sales meta
  78. WordPress search query, how to modify the sql
  79. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  80. Windows Setup: Error establishing a database connection
  81. The plugin generated 225 characters of unexpected output during activation
  82. WAMP SERVER Command Prompt SET PATH=%PATH%
  83. WordPress select query issue
  84. How can get all users by current user meta (array)?
  85. What to create new post using wp_insert_post, but it repeat the post infinitely
  86. Send data from plugin to external database
  87. Processing forms with php to wordpress database
  88. How to connect database table to each registered wordpress user.
  89. See output of a sql query while plugin installation in wordpress
  90. Using the same shortcode to show any table from the database
  91. Querying multiple meta_keys in WordPress SQL query
  92. Cannot Upload Custom Header Image into WordPress Dashboard
  93. Predefine Magazine Style Layouts
  94. I am unable to fetch json data from wp_db
  95. How to send push notification in android using php? [closed]
  96. How to set variable to specific field when querying
  97. Search results always returns “No results” no matter what
  98. Getting invalid user ID error when creating a new user with wp_insert_user
  99. Custom form that stores data in mysql database
  100. Retrieve data from external database and insert back in