Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Jean MAURICE
Hi Bill : unknown alias ta ! The Foxil Le 28/10/2014 22:08, Bill Anderson a écrit : Jean, That should fail. The column names would not be available to be used in the SELECT portion of the clause. If you use the HAVING clause as part of the join, the column names are available to be used.

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Laurie Alvey
The only way I've found to do this is to use an external function, like this: CLOSE DATABASES ALL *!* Source tables have 100 rows of random integers USE colmin1.dbf USE colmin2.dbf IN 0 USE colmin3.dbf IN 0 USE colmin4.dbf IN 0 CREATE CURSOR cout (f1 I, f2 I, f3 I, f4 I, minv I) INSERT INTO

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Stephen Russell
On Wed, Oct 29, 2014 at 7:25 AM, Laurie Alvey trukke...@gmail.com wrote: The only way I've found to do this is to use an external function, like this: CLOSE DATABASES ALL *!* Source tables have 100 rows of random integers USE colmin1.dbf USE colmin2.dbf IN 0 USE colmin3.dbf IN 0 USE

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Bill Anderson
Jean, I think issue is a flaw in the JOIN. I don't see how ta ties to the rest of the join. FROM cantine_services sv ; INNER JOIN cantine_salles sal ON sv.salle = sal.clef, ; tarifs_cantine ta ; WHERE ta.anscol = lcannee INTO CURSOR I don't see how tarif_cantine (ta)

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Virgil Bierschwale
I did something similar to what steve said, and I basically put all the data in one merged table and did the following mysql query on it SELECT V, U, H, MIN(cast(P as decimal)) AS L_SALARY, MAX(cast(P as decimal)) AS U_SALARY, SUM(T) AS W_COUNT, COUNT(U) AS H_COUNT FROM `wp_lca_2013` where

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Jean MAURICE
Hi Bill, this is not an error ! cantine_services and cantine_salles are linked together (it's a school restaurant, pupils are dispached in 4 groups that eat in 2 rooms) but tarifs_cantine is independant (it's the cost of different menus) and I want a 'cartesian product' (?) : on line per

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Jean MAURICE
today, the simplest way to solve the issueis the ICASEgiven by Paul Hill. The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Ricardo Molina
You don't have to make as many comparisons as Paul suggested, make 3 comparisons, then 2 then 1: SELECT DISTINCT ta.codtarif AS tarif, ; sv.clef AS clefserv, sv.salle, sv.capacite AS servdispo, sv.libelle AS service, ; sal.capacite AS salledispo, sal.libelle AS nomsalle, ; ta.capacite AS

Re: Fascinating Foxes

2014-10-29 Thread Ted Roche
We have a family of foxes in the neighborhood. Last year, they wintered over in the fields near our house, a female and two kits. They were fun to watch. On Tue, Oct 28, 2014 at 5:43 PM, Ed Leafe e...@leafe.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Well, I couldn't label this

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Bill Anderson
Jean If you take out the Disponible field does the query work and produce accurate results? Bill Anderson On Wed, Oct 29, 2014 at 3:39 AM, Jean MAURICE jsm.maur...@wanadoo.fr wrote: Hi Bill : unknown alias ta ! The Foxil Le 28/10/2014 22:08, Bill Anderson a écrit : Jean, That should

Re: SQL MIN() et VFP MIN()

2014-10-29 Thread Jean MAURICE
Yes. For years I have written CAST(O AS Integer) AS disponible in the SQL query followed by a REPLACE ALL after the query. The Foxil Le 29/10/2014 16:21, Bill Anderson a écrit : Jean If you take out the Disponible field does the query work and produce accurate results? Bill Anderson