I think you have to use a (user)connection object to achieve that as you can't even alias a column.
otherwise something like
select myfield, count(myfield) as cnt from mytable group by myfield
would achieve it...
Pieter
_____
From: Ibrahim Kilicarslan [mailto:[EMAIL PROTECTED]
Sent: 25. november 2004 20:47
To: [EMAIL PROTECTED]
Subject: [development-axapta] Select distinct
Hi,
How can i implement "Select distinct" SQL clause in Axapta or is
there any possibility to do so.
Thanks in advance...
�brahim
Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://us.ard.yahoo.com/SIG=129sascvv/M=298184.5639630.6699735.3001176/D=groups/S=1705006764:HM/EXP=1101504028/A=2434970/R=0/SIG=11edksnhv/*http://www.netflix.com/Default?mqso=60185402>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=:HM/A=2434970/rand=166250171>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
