Use the appropriate
SQL Joins[
^] to achieve your objective, e.g.
select b.branchid, b.branchname, e.empid, e.empname from branchtable b right join emptable e on
b.branchid = e.branchid
will give you
branchid branchname empid empname
1 A 1 Ram
2 B 2 Suresh
1 A 3 Vinay
NULL NULL 4 Rahul
3 C 5 Sam