Sample Header Ad - 728x90

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