db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Witold Szczerba <pljosh.m...@gmail.com>
Subject Re: Query execution never ends
Date Fri, 19 Mar 2010 14:37:29 GMT
2010/3/19 Bryan Pendleton <bpendleton.derby@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).

Mime
View raw message