SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tableA (
  prodCode integer
  );
insert into tableA values 
(111), (222), (223);
3 rows affected

create table tableB (
  prodCode integer, 
  status varchar(20), 
  date date
  );
insert into tableB values 
(111, 'Done', '2001-01-10'), 
(111, 'Start', '2001-01-01'), 
--(222, 'Done', null), 
(222, 'Start', '2001-01-02');
3 rows affected

select 
 a.prodCode, 
 max(case when b.status = 'Start' then Date end) as start_date, 
 max(case when b.status = 'Done' then Date end) as end_date
from 
 tableA a
left join 
 tableB b
  on a.prodCode = b.prodCode
group by a.prodCode
order by 1


prodCode
start_date
end_date


111
2001-01-01
2001-01-10

222
2001-01-02
null

223
null
null


Warning: Null value is eliminated by an aggregate or other SET operation.