 |
 |
Archives of the TeradataForum
Message Posted: Tue, 24 Feb 2009 @ 20:21:03 GMT
| Subj: | | Re: Too much time spent on aggregate function |
| |
| From: | | Dieter Noeth |
Simard Rudel wrote:
| | Like you see, english is not my native language, so may be I exposed the problem to simplistic ;-) | |
It's my native language neither, but my french is not better :-)
> > ---------- Last group of service ----------
> >
> > LEFT JOIN ((SELECT A.NO,A.NO_ACTIV,A.NO_ASK,
> > MAX(R.NO_REGR_MES) NO_LAST_GROUP_SERV
> > FROM ........
That's it, it looked like "........" is "DB_NAME.TREGR_MES", but "........" is a different table?
> > GROUP BY 1,2,3) AS TNO_REGR
> >
> > INNER JOIN DB_NAME.TREGR_MES ON
> > .........
> > AND TNO_REGR.NO_LAST_GROUP_SERV =
> > TREGR_MES.NO_REGR_MES)
> >
> > ON .....
Dieter
| |
