sql insert query needed

Posted by masfenix on Stack Overflow See other posts from Stack Overflow or by masfenix
Published on 2010-06-07T14:31:35Z Indexed on 2010/06/07 14:32 UTC
Read the original article Hit count: 275

Filed under:
|

Hey guys, so I have two tables. They are pictured below.

I have a master table "all_reports". And a user table "user list". The master table may have users that do not exist in the user list. I need to add them to the user list.

The master table may have duplicates in them (check picture). The master list does not contain all the information that the user list requires (no manager, no HR status, no department.. again check picture).

This is the MASTER TABLE

this is the user table

© Stack Overflow or respective owner

Related posts about sql

Related posts about access