using SUM() but having more than one table in SELECT

[jwk811]

$sql = "SELECT sum(tbl1.number) FROM tbl1, tbl2";

 

it only works if i have one table when i add the second it doesnt work. i just need the sum in one column from one table i just need other info from the other table too it wont work tho. im getting an entirely different number for the sum.

[btherl]

Can you be more specific about what you want?  There's many ways you can combine data from two tables.

[jwk811]

i want to count one column but get other info from more than one table at the same time

[mikosiko]

i want to count one column but get other info from more than one table at the same time

 

here is a quick example for you to adjust to your tables... notice the way the tables are related using an INNER JOIN (in this case), and the GROUP BY clause allow you to give correct result for the aggregate function SUM

 

SELECT P.productCode,
       P.productName,
       SUM(priceEach * quantityOrdered) total
FROM orderdetails O
INNER JOIN products  P ON O.productCode = P.productCode
GROUP by productCode
ORDER BY total