I did it this way:

SELECT
A.ProductCode,
CASE A.FranchiseCode
WHEN ''
THEN B.FranchiseCode
ELSE A.FranchiseCode END AS FranchiseCode

FROM Table_A AS...