Convert SQL INNER JOIN in E1 UBE

I have a SQL statement with INNER JOIN and need to convert to E1 UBE

SELECT CDAN8,CDCRTU,CDCRTJ,ANAA20,ANAA04,ANEV02,ANBLYR,ANMNTH 

FROM PRODDTA.FQ660004 A INNER JOIN PRODDTA.FQ660007 B ON A.CDUKID = B.ANUKID

ORDER BY CDAN8

There are 3 types of joins beside simple =, I tried all of them (right outer, left outer, SQL92 left outer) and the output are all the same

Please let me know if you have any suggestion on how to handle in the BSVW and the Event Rules creation.

Thanks

E910 TR 9.1.5.10