Search:

thanks for your help! I got the point and since if we cannot represent the record with primary key then it would be difficult to join the table....

Regards
Awais khan

Thanks for your time, and help

your query give me following output,

however I need
mileage sum(amount)
0 25134337
1 40000
2 500

yes it does...


ID count(*)
0 2
639077 2
1468482 2
1564561 2
1612265 2
1688768 2

Well actually I want to get the frequency for mileage (category) variable vs invoice amount

Simply saying that I want to sum all invoice amount with car mileage 0, 1, 2,3,4,5 and group them in...

Well thanks for your quick feedback!

I currently run

SELECT c.mileage, SUM(amount)
FROM claims c
INNER JOIN invoice_info i
ON i.ID = c.ID AND i.accident_date = c.accident_date
GROUP BY...

I have a large database, Where I have two tables claims and invoices. In invoice table when I run the query

select sum(amount) from invoices.
Gives me value of 207859507

However when I join...