Ok Guys, I hope you can point me in the right direction.
I want to create a new table in a database that consolidate parts of two different tables.
Example: I have Table 1: includes name, age, gender, etc
Table 2: includes zip code, status, etc
How can I copy a few fields from each table into a third table and keep it up to date?
Should I create a new table and just populate it with lookups?
Thanks for you time and help.