[Solved] Using Sql to get result from two tables

Question

SELECT t.name,SUM(s.amount)
FROM Table1 t
JOIN Table2 s
 ON(t.partid = s.partid)
GROUP BY t.name

You also should get FDK 500 in your result set , so I assume you need a WHERE clause ?

WHERE t.name="DDU"

Accepted Answer

SELECT t.name,SUM(s.amount)
FROM Table1 t
JOIN Table2 s
 ON(t.partid = s.partid)
GROUP BY t.name

You also should get FDK 500 in your result set , so I assume you need a WHERE clause ?

WHERE t.name="DDU"