Error in Joining two tables

[#1]

Good Morning to all,

I have a problem in joining the Fact table (QVFW) and Dimention table (Trend) the source which I am using is AS400.

I have tried as in the below but it throws error, is anyone can help how to join these two tables.

QVFW:
SQL SELECT 

OHHNUM,

OHHSUB

OHHLOC,

ORECOD

FROM S104F31D.DTA.REDFW6 Join S104F31D.DTA.REDFTR on REDFW6.OHHNUM=REDFTR.NUM and REDFW6.OHHSUB= REDFTR.SUB
;

Trend:
SQL SELECT

NUM

SUB

LOC

FROM S104F31D.DTA.REDFTR
;

Regards

Joe