query to as400 with join

I have 2 querys which i have to run against as400 one is with just one lib/file name and the other is with two lib/files joined.

the one with only one file/lib is working fine but the the one using a join statement is not working

do i have to change anything in the syntax when iam using join.

select x from lib/file

select y from lib1.file1 inner join lib2.file2

Do you have an "ON" statement in the join? Right now you're returning a cartesian product and you aren't joining on any keys.|||

yes there is an 'ON' statement, group by and order by

select y_id, count(X) from lib1.file1 inner join lib2.file2 on

FILE1.COL1=FILE2.COL1

GROUP BY Y_ID

ORDER BY Y_ID

WHEN I USE iSeries (IBM application) TO RUN THIS QUERY I JUST CHANGE "." TO "/" AND IT WORKS FINE THERE