The problem is there is only 1 record in the cancels table that has a listcode of LM and JulianDate of 347. And if I run a count separate on the cancels table it shows correctly of 1, but when I run it like this with three tables joined together it counts the same amount as the sales. There are two records in the sales table that has listcode of LM and JulianDate of 347, and the records is correct as well. Just the cancels number is wrong. What am I doing incorrectly? Thanks for the help in advance!

Actually, now that I have put big amounts of data into it, every record that has a cancel only shows 1, and not the correct amount. Also, when the sales are off now as well. When I look directly at the sales and do

WHERE listcode = 'AM and JulianDate = '362'

I get 17 sales and when I add those same WHERE in the cancels_view it has 7 records. But when I do the full long query, it has 119 sales and 1 cancel. Why is this?

Actually, now that I have put big amounts of data into it, every record that has a cancel only shows 1, and not the correct amount. Also, when the sales are off now as well. When I look directly at the sales and do

WHERE listcode = 'AM and JulianDate = '362'

I get 17 sales and when I add those same WHERE in the cancels_view it has 7 records. But when I do the full long query, it has 119 sales and 1 cancel. Why is this?

sorry cant understand your scenario from explanationPlease post some sample data and explain what you get and what you actually want.