I have 2 tables, one looks like this:

TABLE ONE

id | Last Name | First Name | Username | Password | Secret Question

and another that looks like this:

TABLE TWO

id | Hobby | Country | 

I want to combine a Select statement that grabs data from both tables and output the results. The following code:

$select = mysql_query("

    SELECT * FROM table_one WHERE Username = 'Bob'

    UNION ALL

    SELECT * FROM table_two WHERE Hobby = 'Baseball'

");

while ($return = mysql_fetch_assoc($select)) {

$userName = $return['Username'];

$hobby = $return['Hobby'];

}

echo "$userName likes $hobby";

results in a The used SELECT statements have a different number of columns error, what am I doing wrong?