>Hi Set > >Wow your query runs like a bat out of hell J 0.16 Milliseconds !! and it >easier to maintain as you say. > >The only issue is that it somehow multiplies the totals by 6 on all results >as compared mine? > >i.e. mine will return an invoice total of say 18500.00 and yours will return >111000.00 > >This is across all the results any idea why? Would you get six times as many rows in your result set with your original query if you didn't have the DISTINCT, Stef? Or are any of the JOINs returning more than one row - e.g. are there six invoices for each entry in journal? This should be fairly simple to fix, but more information about the tables and how unique each JOIN are would be required.
Set
