[RBG7-L] - Re: Can Anyone see anything wrong

[David M. Blocker]

Steve   EITHER you create a VIEW from the select:   CREATE VIEW  DriveCount AS (drivname, cnt) sel drivname, count (pon) from vbd_rep_data1 grouped by drivname   OR   you can create Aliases for each column / _expression_ in your select.   sel drivname, count (pon) as CNT from vbd_rep_data1 grouped by drivname   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Steve Breen To: RBG7-L Mailing List Sent: Monday, November 15, 2004 5:21 PM Subject: [RBG7-L] - Can Anyone see anything wrong I am trying to use this simple sel command to generate totals.   sel (drivname, cnt)as sel drivname, count (pon) from vbd_rep_data1 grouped by drivname   It is not working and I know I am over looking something simple but not sure what it is.?   Looking for advice     Stephen Breen CDI Services, Inc. 3610 Deahl Court P.O. Box 3838 South Bend, IN 46628 574-271-2027 Ext: 200 Fax 574-247-4638 Fax: 574-247-4631 Email: [EMAIL PROTECTED] Web Site www.911roadrepair.com Pager 800-668-8023 Cell 574-339-2356