MySql query gets null tables
up vote
-1
down vote
favorite
SO this is my query:
SELECT user_items.userid, users.id, users.username FROM user_items
LEFT JOIN users ON user_items.userid = users.username
UNION ALL
SELECT user_items.userid, users.id, users.username FROM user_items
RIGHT JOIN users ON user_items.userid = users.username
And this is the result:
Is there a way to remove the tables that say null?
EDIT:
the desired result is that there are no more tables that say NULL
mysql sql join
edited Nov 19 at 14:35
ADyson
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
add a comment |
up vote
-1
down vote
favorite
SO this is my query:
SELECT user_items.userid, users.id, users.username FROM user_items
LEFT JOIN users ON user_items.userid = users.username
UNION ALL
SELECT user_items.userid, users.id, users.username FROM user_items
RIGHT JOIN users ON user_items.userid = users.username
And this is the result:
Is there a way to remove the tables that say null?
EDIT:
the desired result is that there are no more tables that say NULL
mysql sql join
edited Nov 19 at 14:35
ADyson
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
1
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
INNER JOINneed result in both tables
– jjoselon
Nov 19 at 14:22
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
SO this is my query:
SELECT user_items.userid, users.id, users.username FROM user_items
LEFT JOIN users ON user_items.userid = users.username
UNION ALL
SELECT user_items.userid, users.id, users.username FROM user_items
RIGHT JOIN users ON user_items.userid = users.username
And this is the result:
Is there a way to remove the tables that say null?
EDIT:
the desired result is that there are no more tables that say NULL
mysql sql join
edited Nov 19 at 14:35
ADyson
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
SO this is my query:
SELECT user_items.userid, users.id, users.username FROM user_items
LEFT JOIN users ON user_items.userid = users.username
UNION ALL
SELECT user_items.userid, users.id, users.username FROM user_items
RIGHT JOIN users ON user_items.userid = users.username
And this is the result:
Is there a way to remove the tables that say null?
EDIT:
the desired result is that there are no more tables that say NULL
mysql sql join
mysql sql join
edited Nov 19 at 14:35
ADyson
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
edited Nov 19 at 14:35
ADyson
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
edited Nov 19 at 14:35
ADyson
21.9k112443
edited Nov 19 at 14:35
ADyson
21.9k112443
edited Nov 19 at 14:35
ADyson
21.9k112443
21.9k112443
asked Nov 19 at 14:16
nordin leije
226
asked Nov 19 at 14:16
nordin leije
226
asked Nov 19 at 14:16
nordin leije
226
226
1
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
INNER JOINneed result in both tables
– jjoselon
Nov 19 at 14:22
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32
add a comment |
1
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
INNER JOINneed result in both tables
– jjoselon
Nov 19 at 14:22
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32
1
1
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
INNER JOIN need result in both tables– jjoselon
Nov 19 at 14:22
INNER JOIN need result in both tables– jjoselon
Nov 19 at 14:22
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
accepted
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.id - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
And I'm not convinced you need two queries - it looks like a single INNER JOIN should get what you need.
SELECT
user_items.userid,
users.id, users.username
FROM
user_items
INNER JOIN users ON
user_items.userid = users.id
I think you need to check your work more carefully and also possibly study the different types of JOINs in more detail so you understand exactly what they are intended to do.
answered Nov 19 at 14:35
ADyson
21.9k112443
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.id - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
And I'm not convinced you need two queries - it looks like a single INNER JOIN should get what you need.
SELECT
user_items.userid,
users.id, users.username
FROM
user_items
INNER JOIN users ON
user_items.userid = users.id
I think you need to check your work more carefully and also possibly study the different types of JOINs in more detail so you understand exactly what they are intended to do.
answered Nov 19 at 14:35
ADyson
21.9k112443
add a comment |
up vote
2
down vote
accepted
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.id - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
And I'm not convinced you need two queries - it looks like a single INNER JOIN should get what you need.
SELECT
user_items.userid,
users.id, users.username
FROM
user_items
INNER JOIN users ON
user_items.userid = users.id
I think you need to check your work more carefully and also possibly study the different types of JOINs in more detail so you understand exactly what they are intended to do.
answered Nov 19 at 14:35
ADyson
21.9k112443
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.id - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
And I'm not convinced you need two queries - it looks like a single INNER JOIN should get what you need.
SELECT
user_items.userid,
users.id, users.username
FROM
user_items
INNER JOIN users ON
user_items.userid = users.id
I think you need to check your work more carefully and also possibly study the different types of JOINs in more detail so you understand exactly what they are intended to do.
answered Nov 19 at 14:35
ADyson
21.9k112443
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.id - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
And I'm not convinced you need two queries - it looks like a single INNER JOIN should get what you need.
SELECT
user_items.userid,
users.id, users.username
FROM
user_items
INNER JOIN users ON
user_items.userid = users.id
I think you need to check your work more carefully and also possibly study the different types of JOINs in more detail so you understand exactly what they are intended to do.
answered Nov 19 at 14:35
ADyson
21.9k112443
answered Nov 19 at 14:35
ADyson
21.9k112443
answered Nov 19 at 14:35
ADyson
21.9k112443
answered Nov 19 at 14:35
ADyson
21.9k112443
21.9k112443
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53376545%2fmysql-query-gets-null-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What do you mean exactly? I think it'd be helpful if you show what your expected results are.
– Josh Eller
Nov 19 at 14:21
INNER JOINneed result in both tables– jjoselon
Nov 19 at 14:22
I think it's possible that you're simply joining on the wrong columns - it would surely make more sense to join from user_items.userid to users.userid - because those fields have matching values. You'll never get a match from userid to username - one is a number, and the other is a string.
– ADyson
Nov 19 at 14:32