January 12, 2008 at 8:41 am
Hello
I have a database schema,which has several tables which are 5 in all, these tables all have a particular column which icalled total [sum (qtyordered*item_price) as Total] that is been feed from different sources.
Will i need to create a join query to sum up all of the total columns which will also be grouped by
table name/ID?
January 12, 2008 at 3:13 pm
Since you need the totals from each of the five tables, you have to join the tables and group by id.
January 12, 2008 at 8:31 pm
It also depends on how you want your results. You might care to UNION the summary statements together and do some more aggregation on it....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 13, 2008 at 12:27 pm
This is what i have done so far, can anyone tell me what am doing wrong?
select sum(total)
from table_a, table_b,table_c,table_d
where table_a.total = table_b.total
and table_c.total = table_d.total
January 13, 2008 at 12:36 pm
I have also tried to use
select sum(total)as Total_of_All_Tables
from table_a
union
select sum(total)as Total_of_All_Tables
from table_b
union
select sum(total)as Total_of_All_Tables
from table_c
union
select sum(total)as Total_of_All_Tables
from table_d
but need to the table names to be displayed
January 13, 2008 at 1:35 pm
Try something like:
select 'Table_a' as tablename, sum(total)as Total_of_All_Tables
from table_a
union
select 'Table_b' as tablename,sum(total)as Total_of_All_Tables
from table_b
union
select 'Table_c' as tablename,sum(total)as Total_of_All_Tables
from table_c
union
select 'Table_d' as tablename,sum(total)as Total_of_All_Tables
from table_d
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy