for columns, where and order by)
But you can trick it to provide for a group By:
To do this, use the "Where" clause. Give a dummy where and then add
GROUP BY
Example for armast to group by sales person
In the Where clause give : custno = custno GROUP BY salesmn
Your SQL select would be
SELECT <fields you have chosen> ;
FROM <armast> ;
WHERE custno = custno GROUP BY salesmn ;
....
The custno = custno is to satisfy a valid where clause and then the group by.
P.S.: I haven't tried this myself recently, so you might have to tweak
it more than what I have mentioned here.
No comments:
Post a Comment