• We don't know your table structure or your data, making this rather challenging.

    Perhaps you could use Profiler to find out what query, or queries, Navision is executing and compare those with yours?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.