`
HAVING `Mevcut Miktar`<>0
regds,
-Original Message-
From: Aziz DURMAZ [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 22, 2003 13:54
To: Uttam; [EMAIL PROTECTED]
Subject: RE: A query problem...
Its gives an
un.`ID`
---
Th error says : Invalid use of group function.
Can you help me??
-Original Message-
From: Uttam [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 4:06 PM
To: 'Aziz DURMAZ'; [EMAIL PROTECTED]
Subject: RE: A query problem...
>
TECTED]
Sent: Thursday, March 20, 2003 14:06
To: [EMAIL PROTECTED]
Subject: A query problem...
this is my query:
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))
AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
seconddata.depohareket AS d
On 20-Mar-2003 Aziz DURMAZ wrote:
>
> this is my query:
>
> SELECT urun.`StokKodu`,
> urun.`Isim`,
> (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))
> AS
> `Mevcut Miktar`
>
> FROM rootdata.urun AS urun,
> seconddata.depohareket AS depo
>
>
> WHERE urun.`ID` = depo.`U
this is my query:
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
seconddata.depohareket AS depo
WHERE urun.`ID` = depo.`UrunID`
AND depo.`Iptal` = 0
AND urun.`HizmetUrunu` = 0
GROUP
If your three php vars are p1, p2, p3 and the three cols are f1, f2, f3,
don't you just need ...
SELECT ...
WHERE f11 IN ( p1, p2, p3 )
OR f2 IN ( p1, p2, p3 )
OR f3 IN ( p1, p2, p3 )
PB
-
> I have an enigma that I just can't seem to resolve.
>
> ==
>
Hi!
I have an enigma that I just can't seem to resolve.
==
What is Hoped For:
I have 3 variables (called F1, F2 and F3) which will contain either an
integers (a pointer to a "feeback" item in another table, actually) and a
database of questions, each having an F1, F2 and F3, any o
