Yes I just checked my original query will return 6 rows without the distinct



Stef



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 23 June 2015 01:16 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Firebird migration to increase perfomances

>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





[Non-text portions of this message have been removed]