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
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