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.
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
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
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)
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
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
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:
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
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
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
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
11 matches
Mail list logo