AnsweredAssumed Answered

Fields from two tables into one

Question asked by hayden_1 on Mar 5, 2012
Latest reply on Mar 6, 2012 by philmodjunk

Title

Fields from two tables into one

Post

I have two tables:

  • tableA (which includes fields idA (e.g. a123), dateprice) and

  • tableB (which includes fields idB (e.g. b123), dateprice).

How can I create* a new table, tableC, with field id, populated with both idA and idB, (I'll be using the other fields for calculations on the combined data of both tables)?

 

*and have this update when tableA and tableB have new id numbers

Outcomes