>----- Original Message -----

>From: "Jean MAURICE" <jsm.maurice@wanadoo.fr>

>To: <profox@leafe.com>

>Sent: Tuesday, July 10, 2012 3:25 PM

>Subject: Re: Months later ... i have an SQL soluce for "what is the rank

>ofthis data in an index order?"

>

>oh my god !!

>

><Je n'aurais JAMAIS imaginé imbriquer des SELECT dans la clause FROM !!!!

>

>I would never dare use a SELECT in a FROM clause of a SELECT statement

>being

>itself in a FROM clause of a 'upper' SELECT !!!

>

>The Foxil

>

>Jean à Grenoble

>

YES you knew it Jean !

(even if you can't remind it)

In a previous thread within our french newsgroup,

there was a question about filtering a bottom of top of bottom

lot of records, to get the number 'n' within a scalable data lot,

and i told you about imbricating SELECTs FROM clause

three times deep to reach out the result !

Tha't the same way i did it ; when you choose your prime

subset, at first file level asking, you can then bind a recno()

to a field, so it will fit correctly while upsourced to the prior

request. A way to get rid of recno()'s sql ghosts ...

After, it is more than the way it takes to raise the sauce ...

:o)))

Gérard.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/80142FC0B06A441CAD3862A9993594FD@MuriellePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.