any help with select query??

[Debusal]

I have table one and table two

I want to show all records from table one
but also check if in table two is record that are in table one so if
this is ture then
bla=1 if false then bla=2 is it possible?

query-"select tableone.user,tabletwo.user from tableone,tabletwo
tableone.user=tabletwo.user"
it will only show records if I have same users in these tables
but I need to show everyone from table one
if in tableone user match with tabletwo then blabla=1 and so on
??

any hint

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw