IF statement between two joined tables on multiple values

I have two joined tables, I want to create a new column containing a value from one table based on a colum value in the other. e.g   based on table COA1 colum name "accounttype" evaluating to a "S" ...