successful. Please advised.
_SQL = ' Select ProdBom group by itemid where ProdBom.itemid
== '+ '"'+ _item + '"';
_SQL += ' join ProdTable group by CSM_CustomerCode where
ProdTable.Prodid == ProdBom.Prodid';
_SQL += ' join CustTable group by CSM_CustomerCode,Name where
CustTable.CSM_CustomerCode == _ProdTable.CSM_CustomerCode';
_SQL += ' join SalesTable group by
CSM_Package,CSM_LeadCountId,CSM_CustomerCode where
_SalesTable.CSM_MESLotOrderId == _ProdTable.CSM_MESLotOrderId';
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.
