Re: need help with a complicated join

[Harald Fuchs]

In article <NPELIHDNOPDFKPMNKNIIGECFDMAA.daniel@stripped>,
"electroteque" <daniel@stripped> writes:

> man i didnt even know you can do this
> AND s.date > q.date

> i assumed that goes in a where clause ?

No, it must be in the join clause.  If it were in the WHERE clause,
you would throw away the records after the last split.