Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread hugo.lar...@yahoo.com [firebird-support]
Thanks.

Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread hugo.lar...@yahoo.com [firebird-support]
Thanks Dimitry. BR, Hugo

Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.12.2016 8:18, hugo.lar...@yahoo.com [firebird-support] wrote: > *I tried the following but it does not work. * Your join must be right, not left in this case. -- WBR, SD.

[firebird-support] JOIN ON SELECT PROCEDURE

2016-12-05 Thread hugo.lar...@yahoo.com [firebird-support]
Hello, I wonder if I could get help on the following issue. I have a PROCEDURE GETDATES which returns all the dates of a month. 2016-12-01 2016-12-02 And this table TABLE DEBIT ID (INT) DEBITTIME (TIMESTAMP) TOTALSALE (BIGDECIMAL) Every day has multiple row of table DEBIT The request is