I want to filter out the Production Order which has no record exists
in the ProdJournalTable and NWS_ProdJournalTable (table structure same
as ProdJournalTable, for temporary store some information). I use the
following SQL statement to do it but unsuccessful. It will return the
Production Order even it appears in the NWS_ProdJournalTable.
Can any one tell me what's wrong ?
Regards.
Kenneth.
ProdTable prodTable;
ProdJournalTable pjTable;
NWS_ProdJournalTable nws_pjTable;
select * from ProdTable
where prodTable.ProdStatus == ProdStatus::StartedUp
notexists join pjRoute
where prodTable.ProdId == pjRoute.ProdId
notexists join nws_pjRoute
where prodTable.ProdId == nws_pjRoute.ProdId;
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
