Simple Join Help

Caherconree

Member
Hi all,

i am trying to do a simple join after a number of years not doing any sql but somehow i just cannot get the join correct - anyone out there - thanks:

select rpan8,rpco,
Max(rpdgj)
from PRODDTA.F0411
inner join F0411.RPAN8=F0101.ABAN8
where rpco = '2000010'
group by rpan8, rpan8, rpco
order by rpan8
 

Larry_Jones

Legendary Poster
Hi all,

i am trying to do a simple join after a number of years not doing any sql but somehow i just cannot get the join correct - anyone out there - thanks:

select rpan8,rpco,
Max(rpdgj)
from PRODDTA.F0411
inner join F0411.RPAN8=F0101.ABAN8
where rpco = '2000010'
group by rpan8, rpan8, rpco
order by rpan8

Two Things:

Inner Join Syntax - s/b: Inner Join PRODDTA.F0101 ON RPAN8 = ABAN8

Group By Mistake - s/b: Group by RPAN8, RPCO
 
Top