🚀 go-pugleaf

"Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m> wrote:
>aleplgr wrote:
>
>> 
>> "Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m> wrote:
>> > Why do you want to "return a table"?  This sounds like you don't
>> > want separate client tables in Interbase? How many clients are
>> > there? Is that a lot of tables?
>> > 
>> > -- 
>> > Patrick Moloney
>> 
>It's hard understanding what you need to do.  Each message you post
>gives a little more information about what you want. You also include
>bits of your proposed solution - tables etc.  You would probably get a
>better response with less guessing by everyone if you put the effort to
>make a clear and complete statement of what you need to do, and leave
>out your suggestions for the solution in this step one.  It is often
>said that asking the right question is more than half the answer.
>
>-- 
>Patrick Moloney


OK, I didn't mean to be confusing.
I have a 3 columns table: ClientID, Date1 and Date2.
There are at most 1000 different ClientIDs and 10000 rows in this table, it's ordered by ClientID and Date1.
For each ClientID there's at least one pair (Date1,Date2) and at most 10 pairs (Date1,Date2).
I need to return one table with 2 columns: ClientID and Date1 where
if the difference between the actual Date1 and next(Date2) >30 return actual Date1 else if there is no such difference >30 return the greatest Date1 for the actual ClientID. 
next(Date2) is the Date2 that is in the next row of the actual ClientID.
The DBMS is InterBase 7.5