No INNER JOIN and OUTER JOIN

[aria]

Hi All,

We have some issues with FileMaker reporting output that I’m explaining it below:

In both FileMaker and Access we have the same table structure and records.

In MS access I already created report that is called Quary1 that outputs a report very well for our users.

But when we tried to run the same report in FileMaker Pro 10 we get a different report output that it is not correct and it is missing some data.

Can someone let me know why we can’t get the same report output in FileMaker pro?

Here are the link to both FMPRO and ACCESS files:

http://www.4shared.com/file/167496742/fc914e4c/FMPRO_ACCESS1.html

http://www.4shared.com/file/168448042/17d99ba2/TO_FM_SUPPORT2.html

The FileMaker file username is admin with no password.

Thanks in advance,

A