'Combine Multiple Tables into a new table using SQL,by selecting necessary columns from parent table

  1. I'm having around 50 tables and all those tables are updated every minute.
  2. from those 50 tables i want to create a brand new table, that will contain necessary columns.
  3. If any data added in parent table it need to reflect on new table.
  4. All those tables are interconnected to each other.


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source