MySQL question: 2 queries in 1

[eluser]xwero[/eluser]
Mysql only has subqueries from version 5 but many other databases have it i believe.

But what you are trying to do is something like

Code:

select id,username from tbl_user;
select hobby_id from tbl_user_hobbies where user_id=id;

I don't know if it can be done without redundant data using one query but it's possible with a join

Code:

select t1.username,t2.hobby_id from tbl_user as t1 right join tbl_user_hobbies on t2.userid=t1.id;