Update Query, updating wrong table
- From: "matt17@xxxxxxxxx" <matt17@xxxxxxxxx>
- Date: 31 Jan 2007 13:06:37 -0800
What am I doing wrong? Here is the SQL of the update query:
UPDATE tblTestUpdate INNER JOIN tblImportProducts ON
tblTestUpdate.MaterialNumber = tblImportProducts.MaterialNumber SET
tblImportProducts.Each = [tblTestUpdate].[Each]
WHERE (((tblImportProducts.Each)<>IsNull([tblImportProducts].
[Each])));
It keeps updating the wrong table (tblImportProducts)... it will take
the value's which match from tblTestUpdate and put it in the
corresponding fields on tblImportProducts. I am trying to do the exact
opposite
Thanks,
Matt Pierringer
.
- Follow-Ups:
- Re: Update Query, updating wrong table
- From: John Spencer
- Re: Update Query, updating wrong table
- Prev by Date: no zeroes returned
- Next by Date: Re: Crosstab-force rows
- Previous by thread: no zeroes returned
- Next by thread: Re: Update Query, updating wrong table
- Index(es):