Hi Carsten,
I have check your report on that error 6.
But Carsten, everything is COREECT !!!
You do query:
Select Gruppenname, count(STGelesen), MiezeNumber
from Param, Verkettung, Daten
where
Param.RecID *= Verkettung.VerkGruppe and
Verkettung.VerkDaten *= Daten.RecID and
Daten.STGelesen = false
group by MiezeNumber
order by MiezeNumber
Record 6 of table Param is NOT selected because it HAS (!!!) linked record
in table Daten (recID = 17) and that record has Daten.STGelesen = 1,
So this records ARE NOT selected because you want select
Daten.STGelesen = 0. You see?
IF you modify your query as
Select Gruppenname, count(STGelesen), MiezeNumber
from Param, Verkettung, Daten
where
Param.RecID *= Verkettung.VerkGruppe and
Verkettung.VerkDaten *= Daten.RecID
group by MiezeNumber
order by MiezeNumber
Then you see record 6 selected.
I think you was confused because you think that IF you use LEFT OUTER join
then ALL records of Param Table will be selected. But you also use SEARCH
CONDITIONS. You'd could see record 6 if it have NO linked record in table
Daten, then it could be selected by LEFT OUTER join.
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan .AT. paradigmasoft .D.O.T com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on@lists.macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
