I want to SUM a column in one table and SUM a column of another table and have the two SUM results appear in one table of two columns, one row, just as a query (not creat a new table). I tried UNION but this gives one column and two rows.
If a do the following:
The results are massively wrong, they seem to multiply somewhere.
If I have the two tables:
Then I want the result to be
Both tables have column kW along with t_stamp. The ultimate intention is to query multiple tables (all basically recording kW with t_stamp) to get the SUM of each kW column from "start date/time" to "end date/time) into a table that is one row with x amount of columns (depending on amount of kW tables in query). This is for a SCADA package to use to draw a bar graph, i.e. eventually be able to get total kW (SUM) for a 4, 8 or 24 hour period of multiple tables using t_stamp.
I would be happy to exclude the t_stamp for now just so I can get the SUM's.