| Subject | Re: [ib-support] Update using two tables |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2002-02-13T10:58:51Z |
Of the top of my head:
update tableA
set tableA.datefield = (SELECT tableB.datefield FROM tableB
where tableA.number = tableB.number)
I could be wrong,
Set
update tableA
set tableA.datefield = (SELECT tableB.datefield FROM tableB
where tableA.number = tableB.number)
I could be wrong,
Set