sql server - check the presence of a value of a column in another table sql -

i'm new in sql server. i've copy values of column table table b respect column(join) before copying have check whether value exists in table c. if yes copy, otherwise return records values not in table c. query is;

if exists (select branch_id adm_branch inner join ubl$ on adm_branch.branch_code = ubl$.[branch code  ]   adm_branch.branch_code = [ubl$].[branch code] )          update emp_personal     set account_number = ubl$.[account ] , bank_id = 1 , branch_id = (select branch_id adm_branch join ubl$ on adm_branch.branch_code = ubl$.[branch code  ] emp_personal.emp_id = ubl$.[employee id  ])     emp_personal join ubl$     on emp_personal.emp_id = ubl$.[employee id  ]   else      ( select ubl$.[employee id  ],ubl$.[name ],ubl$.[account ],ubl$.[branch code  ]     ubl$) except ( select ubl$.[employee id  ],ubl$.[name ],ubl$.[account ],ubl$.[branch code  ]     ubl$     right join adm_branch on  adm_branch.branch_code = ubl$.[branch code  ]) 

i think following code give idea, i've tried keep column names same, may have make changes:

update emp set emp.account_number = ubl.[account ],     emp.bank_id = 1,     emp.branch_id = adm.branch_id    emp_personal emp join ubl$ ubl on emp_personal.emp_id = ubl.[employee id  ] join adm_branch adm on adm.branch_code = ubl.[branch code  ];  select [employee id  ],[name ],[account],[branch code  ] ubl$  [branch code  ] not in (select branch_code adm_branch);