I have alot of tables that i would like to combine into 1 big table. most of the tables have different amounts of records and may possibly share some field names.
there are two fields in every table where data should be on the same record. they are [LotID] and [WaferID]. if those fields match then i want the data in the table to be put on that record.
what would be the best way to get ALL records into one table and combine data where those two fields are equal?