Alias a field in SELECT

Gunnar Swan GunnarSwan at PracticeToPass.com
Fri Feb 21 14:48:47 CST 2003


I'm using COUNT and GROUP BY.

Problem is ... the records are returned, and the COUNT is named COUNT.
COUNT is a Director keyword, and it is causing a touch of grief ?

How can I alias the COUNT ... so it comes back as 'RecordCount' or some other name?





Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses




More information about the Valentina mailing list