Two tables joined but need help getting one row pulled into query

[common763]

Is your database SQLServer?

JOIN clause does not make sense. Shouldn't it be: INNER JOIN TABLE1 AS nbc

Post the enter SQL statement.

I ended up figuring it out. Basically disregard my JOIN. I changed verbiage and must have mistyped. Here is what solved it.

INNER JOIN BR.NB as nc on CASE WHEN bc.S6='AAA' THEN 'AAA1' ELSE bc.S6 END

I was doing the CASE WHEN outside of the JOIN in the SELECT statement which was too late because the JOIN already ran. This way it took the AAA in table 1 and viewed it as AAA1 in table 2 linking the records. This can be closed. Thanks.