>----- Original Message ----- >From: "Jean MAURICE" <[email protected]> >To: <[email protected]> >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: [email protected] 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.
