2010/3/19 Bryan Pendleton <bpendleton.de...@gmail.com>: >> SELECT count(*) >> FROM contract co >> LEFT JOIN ContractSubject insured ON insured.contract_id=co.id AND >> insured.id=co.insured_id > > In this query, how does the result (the returned count) change when you > change LEFT JOIN to JOIN?
The numbers are almost always the same, it is possible for some contracts not to have insured subjects temporally. Right now the results are: 17667 (left join) and 17666 (inner join).