SQL-Question

[Ruslan Zasukhin]

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

> Then I tested follwowing
> 
> SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name,
> B.Betrag,
> 0,
> 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,
> 0,
> 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
> 
> and I get NULL where I expect 0!!!
> 
> I will make new Bug Entry ;-)) #533
> 
> But UNION itself works fine :-))

At least one good news :-))

> bye
> 
> 
> Claudius
> 
> P.S. I am sorry that I have so much SQL-Statements that doesn't work,
> so I have to make new Bug Entries. But I like Mantis and Valentina.
> Really good Tool and Application.

No problems! You discover excellent bugs and points !


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