SQL-Question

[Ruslan Zasukhin]

On 3/6/05 10:15 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> 
> I would expect that following SQL should work, but I get
> Error: line 3:1: unexpected token: null
> 
> SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name,
> B.Betrag,
> null,
> B.Kommentar, B.Blocked
> FROM Buchungen B, Kategorien K, Konten KZ
> WHERE B.Kategorie_ID=K.RecID
> AND (B.Ziel_Konto=KZ.RecID AND B.Herk_Konto='13')
> AND B.Deleted='0'
> UNION
> SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name,
> null,
> B.Betrag,
> B.Kommentar, B.Blocked
> FROM Buchungen B, Kategorien K, Konten KZ
> WHERE B.Kategorie_ID=K.RecID
> AND (B.Herk_Konto=KZ.RecID AND B.Ziel_Konto='13')
> AND B.Deleted='0'
> ORDER BY B.BDatum, KZ.Konto_Name, K.Kategorie_Name

Actually SELECT NULL this is non-SQL92 standard.

And I do not catch, why you want NULL in select?


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