It sounds like you want to outer join the tables to that you get all
the rows, even if they don't have a flag. So if, according to your
example, Table2 is the one with 10 rows and Table1 is the one with 7
rows, you could do this:
select t2.*, t1.flag
from table2 t2
left outer join table1 t1
on t2.statusid = t1.statusid