Im trying to write a view that will return all the columns from one table and just the columns from another that dont exist in the first table...
Table A Table B
LAST NAME LAST NAME
FIRST NAME FIRST NAME
Do I do a left join to table a with EMPID?