Having has problems with alias

[Beatrix Willius]

Hello,

got a problem with having in sql containing alias fields. With the  
following SQL I get some interesting result

SELECT Message.OriginatorFrom from Message GROUP BY  
Message.OriginatorFrom HAVING OriginatorFrom LIKE '%B%'
works and has correct result

SELECT Message.OriginatorFrom from Message GROUP BY  
Message.OriginatorFrom HAVING Message.OriginatorFrom LIKE '%B%'
Kernel error: 0x51500. Identifier "Message.OriginatorFrom" is not found.

SELECT Message.OriginatorFrom as 'From' from Message GROUP BY  
Message.OriginatorFrom HAVING Message.OriginatorFrom LIKE '%B%'
Kernel error: 0x51500. Identifier "Message.OriginatorFrom" is not found.

SELECT Message.OriginatorFrom as 'From' from Message GROUP BY  
Message.OriginatorFrom HAVING 'From' LIKE '%B%'
Works, but empty result

The last form is the one I need. Variations 2 and 3 should also work  
in my opinion. Using Valentina Studio latest beta on Mac OS 10.5.6. I  
need this fixed urgently.

The website really has me confused. Is Billet or Mantis to be used  
for support tickets???

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.