How to insert/combine values from multiple tables?
0
votes
3
answers
166
views
I have multiple tables (12 for each month) that have 3 columns each ("code", "test_name", "value")
Example:
_______________________________
January
code | test_name | value
0001 name1 17
0002 name2 45
0005 name5 12
______________________________
February
code | test_name | value
0001 name1 3
0002 name2 7
0004 name4 13
_______________________________
March
code | test_name | value
0001 name1 6
0006 name6 32
0007 name7 41
_______________________________
How do I merge or insert or combine it in sql into one table that would look like this:
Year
code | test_name | January | February | March | ...
0001 name1 17 3 6
0002 name2 45 7 0
0003 name3 0 0 0
0004 name4 0 13 0
0005 name5 12 0 0
0006 name6 0 0 32
0007 name7 0 0 41
Asked by Mladen G
(1 rep)
Mar 15, 2016, 07:31 PM
Last activity: Jul 6, 2025, 02:06 PM
Last activity: Jul 6, 2025, 02:06 PM