inner join help

[spires]

Hi,

I'm trying to select all of the 'username' values from two tables.
tables:
user_info
submit1

So i can see whether the username is already taken.

Can anyone see what is wrong with this code? I keep getting "query 2 failed"

Thanks for your help.

[code]
$query2 = "SELECT * FROM user_info INNER JOIN submit1 ON user_info.username = submit1.username WHERE username='$usname'";
$result2 = mysql_query($query2) or die ("query 2 failed");
[/code]

[Guest huey4657]

$query2 = "SELECT * FROM user_info, [other table goes here]

and is

$usname spelt correctly?