Quote
I needed a table in my DB which combines two specific values from each tables which are related and I was able to create it wih an inner joint. The new table is exactly what I need ...
So you've taken values from TableA and TableB and used them to create TableC.
Then TableA and/or TableB change and you want the new values reflected into TableC?
Answer: Don't use TableC.
Instead, create a
View (called, say, "ViewC") that executes the same SQL that you previously used to create TableC.
Your "data" in ViewC will now be updated in
real time as TableA and/or TableB change. (Actually, there is no data
in ViewC; it's just a Select statement with a Name). The actual data remains in TableA and TableB.
Regards, Phill W.