solve this query pls.LEFT OUTER JOIN.

[25884]

hi All!
i am trying to find out the exact sequence of events which happen when the query that follows the table structure
is executed ------any help anyone?

Thanks a lot.
SSR.

animals
family name
mammal dog
mammal lion
fish guppy
bird eagle
insect beetle
bird pelican
fish bass


blood_types
family blood_type
mammal warm-blooded
fish cold-blooded
bird cold-blooded

SELECT a.family, a.name FROM animals a
LEFT OUTER JOIN blood_types t ON a.family = t.family
WHERE a.family NOT IN ('fish', 'bird')
How many rows are returned by the query above?

 

[tlbroadbent]

The query should return 3 rows.

mammal dog
mammal lion
insect beetle
Terry

X-) "Life would be easier if I had the source code." -Anonymous