Multi join query returns to many results and improperly matched
- by Woot4Moo
I have the following minimal schema in Oracle: http://sqlfiddle.com/#!4/c1ed0/14
The queries I have run yield too many results and this query:
select cat.*, status.*, source.*
from cats cat, status status, source source
Left OUTER JOIN source source2
on source2.sourceid = 1
Right OUTER JOIN status status2
on status2.isStray =0
order by…