🚀 go-pugleaf

Hi:

This is small test example of what I want and the query that produced 
it. I am having problem with filtering the records with where clause 
like I said earlier. The problem is the selection criteria is not 
mutually exclusive.

Perhaps my subject line was misleading.

Anyway, this is how I am using F_MAXDATE.


select m.id, m2.id, m2.yearm2, m2.crdrpt_rnw, m3.id, m3.yearm2, 
m3.crdrpt_rnw, F_MAXDATE(m2.crdrpt_rnw, m3.crdrpt_rnw)
FROM
     "MEMBERS" m
     LEFT OUTER JOIN "MEMPAY2" m2 ON m."ID" = m2."ID"
     INNER JOIN "MEMPAY2" m3 ON m2."ID" = m3."ID"
where m2.yearm2 = '2007' and m3.yearm2 = '2008' and ((m2.crdrpt_rnw is 
not null and m3.crdrpt_rnw is null) or
                                                      (m2.crdrpt_rnw is 
not null and m3.crdrpt_rnw is NOT null))

Example of output:

173 173 2007 01/12/2007   173        2008      01/12/2008    01/12/2008
176 176 2007 06/02/2007   176        2008      06/02/2008    06/02/2008
178 178 2007 06/22/2007   178        2008      06/22/2008    06/22/2008
180 180 2007 01/02/2007   180        2008      01/02/2008    01/02/2008
182 182 2007 04/12/2007   182        2008      04/12/2008    04/12/2008
200 200 2007 08/13/2007   200        2008      08/13/2008    08/13/2008
205 205 2007 02/09/2007   205        2008      02/09/2008    02/09/2008
206 206 2007 02/16/2007   206        2008      02/16/2008    02/16/2008
217 217 2007 08/30/2007   217        2008                    08/30/2007
218 218 2007 02/23/2007   218        2008      02/23/2008    02/23/2008
220 220 2007 12/03/2007   220        2008                    12/03/2007
224 224 2007 05/21/2007   224        2008      05/21/2008    05/21/2008
230 230 2007 10/13/2007   230        2008                    10/13/2007