Re: How do I add two table values and publish to a third table?
- From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
- Date: Sat, 23 Apr 2005 12:15:50 -0700
"=?Utf-8?B?UHJlbGx5YW4=?=" <Prellyan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:C6B59CBB-754B-413A-8F0E-7184D2E27906@xxxxxxxxxxxxx:
> (v1 in table A) + (v2 in table B) = (v3 in table C)
>
> Is there a quick way to do this.
>
Which v1, v2 and v3 values? There is one of each for every row in the
tables, so if you have 1000 rows in each table there are a billion ways
of answering this! At the moment, all you have described is that you want
to add NumberOfPassengers to PencePerKilogramme and store the answer in
DaysSinceDischarge.
Presumably you do have some way of joining all three tables together:
once you have done that, then the addition is a simple UPDATE query. Post
more information if you need further help.
B Wishes
Tim F
.
- References:
- How do I add two table values and publish to a third table?
- From: Prellyan
- How do I add two table values and publish to a third table?
- Prev by Date: Re: Rounding numbers
- Next by Date: Re: multiple tables
- Previous by thread: Re: How do I add two table values and publish to a third table?
- Next by thread: RE: How do I add two table values and publish to a third table?
- Index(es):
Relevant Pages
|
