Pieter
_____
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of kamchung322
Sent: 25. mai 2005 08:18
To: [email protected]
Subject: [development-axapta] Count no of record in Join statement
Hi All
Is it possible to count no of record in join statement ? I try the
following SQL statement but return error.
select count(recId) from purchLine group by (recId) WHERE
purchLine.PurchStatus == PurchStatus::BackOrder join PurchPoolId from
PurchTable where PurchTable.purchId == purchLine.PurchId &&
purchTable.ItemBuyerGroupId == 'Buyer1';
Regards.
Kenneth.
_____
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]
be>
* 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 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.
