[V4RB 0000496]: SQL-Problem

[Ruslan Zasukhin]

On 2/28/05 5:31 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> 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'
> 
> faster too?

No, do not think so.
May be only for parser will be easier. But this is not main time usually

-- 
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
-------------------------------------------------------------