ccDan - 11:24 pm on Jun 13, 2010 (gmt 0)
It's not tied to the animals table by name. If there are no states records for 'WA', it will **only** match on area records for 'OR' where it joins on name. Which is the desired effect. So bracket them,
WHERE (states.area = 'WA' OR states.area = 'OR')
AND animals.name = states.name
and that should fix it.
Bingo! Yep, that fixed that part of the equation. Thanks!
Let me know if it works.
Yes! Thanks much!
I did it like this:
From animals Where name In
(Select name From states Where state = 'WA' Or state = 'OR')
Order By name Asc
And that did the trick.