Re: [GENERAL] Join three fields into one on same table

2008-06-02 Thread jrivero
Very thanks Scott!! this is the solution was need :) Jordi On 19 mayo, 23:36, [EMAIL PROTECTED] ("Scott Marlowe") wrote: > On Mon, May 19, 2008 at 4:51 AM,jrivero<[EMAIL PROTECTED]> wrote: > > Hi, i need help for a query. I have three fields, year, month and day > &g

[GENERAL] Join three fields into one on same table

2008-05-19 Thread jrivero
Hi, i need help for a query. I have three fields, year, month and day into table and need join and update another field named date on same table. My problem is not that make update query. With this query have the value of the update: > select year || '-' || month || '-' || day || ' 01:00:00' as n