Re: left jon returning wrong record count

[Harrison Fisk]

Hi,

Why do you think this is the wrong result? Nothing you have shown indicates why. If you have multiple matches in the agendatotal table, then you can get more rows than is in mavaodafone.

For example:

table 1 data:

1
2
3
4
5

table 2 data:
1
1

table 1 count(*) = 5
table 2 count(*) = 2
table 1 left join table 2 count(*)= 6

Perhaps you want to do a count(distinct) which would return to you 14626, though I don't know why you would want that.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com