JOIN TWO TABLE

[AP718]

From the below example please show how can I take the columns from T1.A and T1.B and join the T2.B column?

T1.A	T1.B		T2.A	T2.B
BLK	234		BLK	768
WHITE	123		WHITE	8765
BLUE	456		BLUE	234
T1.A	T1.B	T2.B
BLK	234	768
WHITE	123	8765
BLUE	456	234

[Kurt_Bremser]

You join on T1.A=T2.A, that's obvious, isn't it?

proc sql;
create table want as
select
  T1.A,
  T1.B,
  T2.B
from T1 left join T2
on T1.A = T2.A;
quit;

[Patrick]

And because column B exists in both source tables you need to rename it for the target table as there can't be two columns with the same name in the same table. Below @Kurt_Bremser 's SQL amended accordingly.

proc sql;
  create table want as
    select
      T1.A,
      T1.B as T1_B,
      T2.B as T2_B
    from T1 left join T2
    on T1.A = T2.A
    ;
quit;