SELECT (SELECT user_id FROM users WHERE user_id=1) AS user_id, (SELECT usersetting_user_id FROM usersettings WHERE usersetting_user_id=1) AS usersetting_user_id;
this returns:
| user_id | usersetting_user_id |
| 1 | 1 |
but I want to display all users, not just one. So I run the following:
SELECT (SELECT user_id FROM users) AS user_id, (SELECT usersetting_user_id FROM usersettings) AS usersetting_user_id;``
and get:
ERROR 1242 (21000): Subquery returns more than 1 row
Any idea how to circumvent this?