Table matching


I’m new AX 2009 programmer. My first project is to match two table contents and then display the mis-matched data. Would someone help me start on this? Thanks

In two tables are not in database and I needs to be imported. Any idea on how to do that? tables are in .csv file

use notexist join for that two tables…


Using NoExists Join it will return Mis-Matched Records

Thanks guys I’ll try that. One problem though is the two tables have different time zone. How do I adjust the time?

Would any of you give me a sample code on how to do the table data matching.


Hope you found what you were looking for. Just in case, SQL examples can be found here -