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,t abletwo.user from tableone,tablet wo
tableone.user=t abletwo.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/mysql?unsub=m...ie.nctu.edu.tw
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,t abletwo.user from tableone,tablet wo
tableone.user=t abletwo.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/mysql?unsub=m...ie.nctu.edu.tw