[luthier00]

SELECT person, SUM(payment) AS Expr1
FROM (SELECT Table2.person, SUM(Table2.expr) AS exp1
FROM Table2 INNER JOIN
Table1 ON Table2.person= Table1.person
GROUP BY Table1.person) AS t
GROUP BY person

I am going to crazy... :S

[modi123_1]

No.. no.. NO! Do not do the inner join where you are doing the sum. That sum bit goes into a sub query and you join off the subquery.

[luthier00]

May be i did not tell.. i dont know english very well.

[luthier00]

SELECT SUM(payment) AS Total
FROM (SELECT SUM(expr) AS Expr1
FROM Table2
WHERE (person= table1.person)) AS x
GROUP BY x.person

will you help? I am going to kill myself.

Is your teaching way?

[modi123_1]

Okay.. maybe if I drew it out... and colored it.

See - the blue table doesn't see the peach guts of the subquery.. it just interacts with it as if it's a table. Aka.. blue only gets to lime but doesn't see peach.

The summing happens in the peach but blue doesn't care - all it knows is there are values summed and things to join off of.



Also I would advocate not taking your life.

Quote

Is your teaching way?

What?

[luthier00]

SELECT b.person, SUM(b.payment) AS Expr1
FROM Table1 AS b INNER JOIN
(SELECT person, SUM(expr) AS sval_sum
FROM Table2
GROUP BY person) AS a ON a.person= b.person
GROUP BY b.person

resutls:

John 100
Mark 100
etc 100

I need john payment total and expre total. ?

[modi123_1]

Why are you summing anything on " Table1 AS b"? That table doesn't hold values to sum up.. (or at least it shouldn't).

[luthier00]

Look my first post? Why i shouldnt sum table1?

[modi123_1]

Sorry - table 2... why is that in the subquery?

[luthier00]

table1
Mark 10
Mark 10
John 10
John 100

table2
Mark 10
John 30
John 300
Jess 10

query result must be:

person-totalontable1-toltalontable2
Mark - 20 - 10
John - 110 - 330
Jess - 0 - 10

[modi123_1]

Those hyphens are to separate columns? then again - why are you summing up anything in table 2?

[luthier00]

What gives me total in table2?

[modi123_1]

I don't know what that means. I saw table 2 holding a name I could join off of from table 1 and some value... a value that was different than the values held in table 1.

[luthier00]

What is ur mission? Apperently it is not to help. May be u know, but u cant teach!

[modi123_1]

Clearly I have a different view on where the problem is.. but cest la vie and adieu.