select branchdata.dbo.acmast.acmastid,branchdata.dbo.acmast.account from branchdata.dbo.acmast
where branchdata.dbo.acmast.acmastid not in(
select hodatabase.dbo.acmast.acmastid from hodatabase.dbo.acmastid)