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/[EMAIL PROTECTED]