Update Query

[Ajay]

I have two tables, Table A contains email Ids and SSN and Table B contains email Ids and SSN apart from all the information about an employee like his first name, last name etc etc.
Now my question is, there are few records in Table B whose email Ids are NULL, now by comparing the SSN of Table A with SSN of Table B I need to get the email Ids of those records whose email Ids are null in Table B and insert them in table A.
I need to execute this using one query in Microsoft Access.

[Tom]

If the EmAIL idS ARE STATIC, WHY DO YOU NEED TABLE A?


------------
Ajay at 2/20/2002 4:48:50 PM

I have two tables, Table A contains email Ids and SSN and Table B contains email Ids and SSN apart from all the information about an employee like his first name, last name etc etc.
Now my question is, there are few records in Table B whose email Ids are NULL, now by comparing the SSN of Table A with SSN of Table B I need to get the email Ids of those records whose email Ids are null in Table B and insert them in table A.
I need to execute this using one query in Microsoft Access.