Type: Posts; User: mawais31
Search took 0.01 seconds.
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....
Thanks for your time, and help
your query give me following output,
however I need
yes it does...
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
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...