Join imitating not exists

select *  from

(

select 1 id,'herby' name

union select 2 id,'john' name

) a

left join

(select 1 id ,23.56 amount) b

on a.id = b.id

where b.id is null