Help with update query

[Matt Williamson]

I have 2 tables that I want to join together into one. In tableA there is a
lot of missing data in a field that tableB has. The common field between the
tables is unique in tableB but in tableA is indexed with duplicates (very
few, but enough to warrant indexing that way)

The query that I came up with to do this is:

UPDATE tableA
INNER JOIN tableB ON (tableB.tax_id = tableA.PSSN)
SET tableA.AccountNo = [tableB]!

;

When I run the query it tells me it's going to update more rows than exist
in tableA in the first place.

What am I missing here and how can I change this to a select query to see
what data will be returned?

TIA

Matt

 

[KARL DEWEY]

Backup your tables - NOT TESTED !!

UPDATE tableA
INNER JOIN tableB ON (tableA.PSSN=tableB.tax_id)
SET tableA.AccountNo = [tableB]!

;