In article <001801c57c21$7f09a270$0e02a8c0@...>, Arno Brinkman wrote:

> I doubt you'll find an easy and cheap query:
>

I've been coming to that conclusion, to make matters worse I need a
generic solution as the number of sol records is indefinate (my example
had 3 but it could be 300)

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly