select from two tables

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I want to verify if a certain value in a field already exists in two
tables, I've tried this:
SELECT * FROM xymply_users,xymply_newusers WHERE xymply_users.user
='test' OR xymply_newusers.user ='test'
With thisquery, a record where xymply_users.user contains 'test' does
not show up, why not i'm wondering??? What am i doing wrong?

Site Timeline