This means table ABC and XYZ do not have any rows with the same keys used to join them. The join returns no values. You would need to check this condition. Could be you have a formatting issue in your data.

Check the JOIN first within an transformation like

SELECT * FROM ABC

INNER JOIN XYZ ON

ABC.XXX = XYZ.XXX

Sometimes it might be useful to check if the values are really the same in both tables by also checking the lengths e.g.

SELECT LENGTH(XXX) FROM ABC;

SELECT LENGTH(XXX) FROM XYZ;

maybe there are some spaces or other characters in one of the fields that lead to the situation that the JOIN is not working correctly. If that is the case you can make use of TRIM or SUBSTRING function in order to make both fields match to each other.

BR

Dennis