Vlookup and Iferror in sql query

[vishant]

I have two set of data Table A and Table B

Table A
Day Catgry
Sat Shift
Mon Working
Tue Leave
Wed Working
Thur Working
Fri Working
Sat Flexi
Sun Flexi

Table B
Day Status
Sat Holiday
Mon Working
Tue Working
Wed Flexi

I want to have a new column with lookup Table A- Day and Match Table B Status if no match then null and to fill the null in the new column from catgry

so the out put for New column in Table A would be

Table A
Day Catgry New status
Sat Shift Holiday
Mon Working Working
Tue Leave Working
Wed Working Flexi
Wed Working Flexi
Fri Working Working
Sat Flexi Holiday
Sun Flexi Flexi


Please advice.

Thanks
Vishant