SQL Left Join

[WilliamB]

Hello,

I'm trying to get that

a	b	Copt
Tom	52	45678
Titi	88

But my code does not work:

Here is my code and my tables

Data employee;
input a $ b;
datalines;
Tom 52
Titi 88
;
run;

Data portefeuille;
input b Copt D;
datalines;
52 45671 201929
52 45678 201930
56 45897 201930

;
run;

proc sql;
create table comp as
select emp.*,Port.Copt
from employee as emp left join portefeuille as Port on Port.b=emp.b
where Port.D = 201930;
quit;

Thanks for your help

[novinosrin · Accepted solution]

Use AND

from employee as emp left join portefeuille as Port on Port.b=emp.b
and Port.D = 201930;

[WilliamB]

Thank you so much. Have a good day