any help with select query??

2003-07-24 Thread 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

RE: any help with select query??

2003-07-24 Thread Rob
] Subject: any help with select query?? 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