Originally Posted by campkev

ok, i am assuming that you want a name for all id's. if a has an entry use that, otherwise use the name from b. also assuming that B has an entry for every id. if those assumptions are correct, then this should work

Help with Code Tags

(Toggle Plain Text)

select b.id, isnull(a.name,b.name) as [Name] from b
left join a on b.id = a.id

select b.id, isnull(a.name,b.name) as [Name] from b left join a on b.id = a.id