selecting two tables from mysql

[rulian]

okay, what I need to do is make a query that will select the same named column on two tables. because my user library is split into two tables, but all names must be unique and accessed for loggin in. So I need to check for the username in both tables and get the info from the one that matches. in my book it says it's possible to select a column from two tables like so

select username from users1, users2 where username='$username'
but it warns me that the columns are ambiguous
so it tells me to do this:
select user1.username, user2.username from user1, user2 where username='$username'

but this doesnt work, so how could I do this?

[Anon]

Try this:

SELECT user1.username, user2.username
FROM user1, user2
WHERE user1.username=user2.username
;

[jc94062]

Alternativly use join...

SELECT * FROM user1 LEFT JOIN user2 ON user1.username=user2.username

pretty much the same, but I find it neater, and easier to select more things, depends on how much data you want to grab from the two tables.