I have 2 MySql tables. How to get not all data from them in 1 sql query?

Question

I have 2 MySql tables. users with an identifier and username; streams with userId and streamId. How to get them as / append them to a single table containing only username | streamIdas an SQL response? With one SQL query.

Answer 1

you can do the following:

select a.username, b.streamId
from names a, streams b
where a.userId = b.userId;

Answer 2

select tb1.username, tb2.streamid 
from tb1
inner join tb2 on tb2.userid = tb1.userid

The answer above returns the same results, just contains an implicit connection, which is slower for me.

Answer 3

select u.username, max(s.streamId) as streamId
from users u
inner join streams s on u.id = s.userId
group by u.username