Hello All,
While trying to write an sql querry I ran into the following case that i can't explain and was wondering if someone could:
run sql select count(numplan.pkid) from numplan
(count)
=======
2721
run sql select count(numplan.pkid) from numplan inner join devicenumplanmap on devicenumplanmap.fknumplan = numplan.pkid
(count)
=======
6169
Inner join is supposed to be the overlap between two sets, which means that there should be no way for the result to be bigger than any of the two sets going in

any ideas?