>>Try
>>
>>select *
>> from person p
>> inner join referral r on p.cl_ref = r.cl_ref
>> where p.cl_dob > (
>> select GOMONTH(min(EVL(rr.re_date, {^9000-12-31}), -216))
>> from referral rr
>> where rr.cl_ref = p.cl_ref )
>
>That seems to fail on the min() function call, it's expecting 2 arguments...
>
>Thanks
>Kev
No, MIN() in SQL SELECT is totaly different function. It gets minimum value of the expression and requires nly one parameter.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.