Re: [GENERAL] "joining" table records

2017-06-22 Thread Moreno Andreo
Il 21/06/2017 19:11, David G. Johnston ha scritto: On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote: I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1 2 11

Re: [GENERAL] "joining" table records

2017-06-21 Thread David G. Johnston
On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote: > I have this table > > rec_code | rec_date | int1 | int2 | > 10 2014-07-21 3 4 > 11 2014-07-21 5 > 10 2015-01-04 1 2 > 11 2016-02-05 6 > > That's the result I need

[GENERAL] "joining" table records

2017-06-21 Thread Moreno Andreo
I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1 2 11 2016-02-05 6 That's the result I need to get from a SELECT statement rec_date | int1 | int2 | tempvalue 2014-07-21 3 4