Update, SQL statement ! Help

[hisham]

What is the SQL statement that allow to update a table using other table,
i have 2 tables the first is "A" contains the field "CardNomber" The second table "B" contain the field "CardNomber1"
i used:
UPDATE A SET CardNomber= [CardNomber]+![CardNomber1];
Thanks in advance

 

[TheVMan]

Hisham,
Are you certain what you want isn't to write an Append query. Based on what you have above, it looks as though you want to set A.CardNomber = A.CardNomber + B.CardNomber1. You haven't specified any criteria to meet, so the query will know which records to update. Make sense?

V