Re: SQL question..

On Feb 5, 5:39 pm, redrose..._at_yahoo.com wrote:
> Thanks for the suggestion but that brings up nothing because in:
>
> > (r.VALUE = '5 Lincoln Ave') AND
> > ((r.NAME='phone') OR (r.NAME = 'fax'))
>
> there is no possible match. r.NAME is 'address' for r.VALUE '5 Lincoln
> Ave'

See Mark D Powell's answer. You will perhaps have to correlate a subquery if foothillbiker's self-join doesn't get you there.

jg

--
@home.com is bogus.
Wreck a few cars?  Just add more sensors!
http://www.fortwayne.com/mld/journalgazette/living/16625858.htm