Want to combine two tables into a third .Both tables are properly written to but inserting the corresponding values into a third table with matching fields to both tables is not working ...
I would like the final table to have all entries of table two in the allocated rows and the entry of table1 fills up the remaining columns allocated to it accross the entire table (If this would help
tab 1
12 sam analyzer
tab2 date 13 mike analyzer
date 14 john work
tab 3 should be
date 13 mike analyzer 12 sam analyzer
date 14 john work 12 sam analyzer