🚀 go-pugleaf

Bill Todd wrote:
> SELECT ID, MAX(D1) AS D1, MAX(D2) AS D2 FROM ATABLE
> GROUP BY ID
> 
> Is that what you want?
> 

Hi:

Thanks.

Little more complicated
Here is the real query. Does not like max

This is from a stored procedure the results of which are used as a text 
(cvs) file upload to update a MySQL table on a website.

I am using the gut of the SP for testing this.

The dates I want come from the same record or two different
record at <--------.


SELECT
        CAST(m."ID" AS INTEGER) AS ID,
        'bong' || (CAST(CAST(m."ID" AS INTEGER) AS VARCHAR(10))),
        m."PWORD",
        PROPERCASESTRING(m."NAMEFIRST",''),
        PROPERCASESTRING(m."NAMELAST",''),
        PROPERCASESTRING(m."DBA",'') ,
        '' ,
        m."EMAIL" ,
        m."PHONE" ,
        CAST(m."RENEW_DTE" AS VARCHAR(10)),  <-----
        SUBSTR(m."NAMEFIRST",1,1) || 'boca' || SUBSTR(m."NAMELAST",1,1) ,
        CAST(m2."CRDRPT_RNW" AS VARCHAR(10))    <----------
FROM
     "MEMBERS" m
     LEFT OUTER JOIN "MEMPAY2" m2 ON m."ID" = m2."ID"
WHERE
  (
  (m."PWORD" IS NOT NULL) AND
     (
     ((m2."YEARM2" = (Extract(Year from CURRENT_DATE))) AND 
(m2."RENEW_DATE" IS NOT NULL) and (m2."DATE_PAID" IS NULL )) or

     ((m2."YEARM2" = (Extract(Year from CURRENT_DATE) - 1)) AND 
(m2."RENEW_DATE" IS NOT NULL) and (m2."DATE_PAID" IS NULL)) or

     ((m2."YEARM2" = (Extract(Year from CURRENT_DATE) + 1)) AND 
((m2."RENEW_DATE" IS NOT NULL) or (m2."CRDRPT_RNW" IS NOT NULL))) OR

     ((m2."YEARM2" = (Extract(Year from CURRENT_DATE) + 1)) AND 
((m2."DATE_PAID" IS NOT NULL) or (m2."CRDRPT_PD" IS NOT NULL)))
     )
)


ORDER BY m.ID ASC