[V4RB 0000496]: SQL-Problem

[Ruslan Zasukhin]

On 2/27/05 12:39 PM, "vbt at paradigma.ukrcom.kherson.ua"
<vbt at paradigma.ukrcom.kherson.ua> wrote:

> Summary:                    SQL-Problem
> Description: 
> Following Code has result 0 records
> 
> SELECT KO.Konto_Typ, KZ.Konto_Typ, B.Kategorie_ID, B.Betrag FROM Buchungen
> B, Konten KO, Konten KZ
> WHERE B.Herk_Konto=KO.RecID
> AND B.Ziel_Konto=KZ.RecID
> AND B.Deleted='0'
> AND B.BDatum<='27.02.2005'
> 
> but it should have a lot

Hi Claudius,

I will recommend redo query using new SQL92 syntax of joins.
This make query more clean.


SELECT     
    KO.Konto_Typ, KZ.Konto_Typ, B.Kategorie_ID, B.Betrag
FROM 
    Buchungen B join Konten KO ON B.Herk_Konto=KO.RecID
                join Konten KZ ON B.Ziel_Konto=KZ.RecID
WHERE 
    B.Deleted='0' AND B.BDatum<='27.02.2005'

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------