I have a database containing(simplifyinga little) a CUSTOMERS table
andan INVOICES table.
INVOICES contains a foreign key to CUSTOMERS, as you can expect.
I want to retrieve rows showing INVOICES data and some CUSTOMERS data so
I use an inner join, and I want to see newer invoices first so I
You could try an outer join ... mucky in the extreme but it sometimes
forces the optimiser to look at the sane table first ... (yes I know one
shouldn't have to do that sort of thing).
On 03/02/2015 12:17, Fulvio Senore mail...@fsoft.it [firebird-support]
wrote:
I have a database
On Feb 3, 2015, at 8:17 AM, Fulvio Senore mail...@fsoft.it [firebird-support]
firebird-support@yahoogroups.com wrote:
I want to retrieve rows showing INVOICES data and some CUSTOMERS data so
I use an inner join, and I want to see newer invoices first so I add an
ORDER BY clause. I only