Access table union - merge data even even non-matches other criteria
Posted on 2014-09-16
I have two tables, "GDW" and "JJHCC" that have the same fields -- User ID and Job Level
I want to create Union by User ID of both tables but I want to use the JJHCC values for Job Level if it exists and only use the GDW information if JJHCC is blank or if that User ID doesn't exist in JJHCC.
GDW has a lot more records than JJHCC so there will be a many that get brought over in the union.
What would the SQL look like for this?
Thanks for your help.