Left join with condition
correct select is:
create table bug (id int primary key, name varchar(20))insert into bug values (1, 'bad name')insert into bug values (2, 'bad condition')insert into bug values (3, 'about box')CREATE TABLE blocking(pk int IDENTITY(1,1)PRIMARY KEY ,id int, name varchar(20))insert into blocking values (1, 'qa bug')insert into blocking values (1, 'doc bug')insert into blocking values (2, 'doc bug')select t1.id, t1.name,(select b.name from blocking b where b.id=t1.id and b.name='qa bug')from bug t1