Table matching

Hi,

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…

Hi,

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.

Hi,

Hope you found what you were looking for. Just in case, SQL examples can be found here - http://msdn.microsoft.com/en-us/library/aa656402.aspx