UPDATE second_table SET date_column = (SELECT min(date_column) FROM
first_table);
On Thu, 28 Oct 1999, Imtiaz. S. M wrote:
> I have two tables which have exactly the same structure. Both of them
> have one datetime column along with three other columns. But the
> datetime column value in the second table is NULL for all the rows. Now
> I want select the least date(date with the least value in the datetime
> column) from the first table and update all the rows in the second table
> with this least date value from the first table. I do not want to use
> any compiler or host variables. I should be able to do this only using
> SQL statements. Cn somebody please help me? Thanks in advance.
>
> regards
> Imtiaz
>
>
> ************
>
>
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden