Re: possible: different WHEREs per column??

From: Michael J. Ort <michael_ort_at_my-deja.com>
Date: 2000/04/17
Message-ID: <8dfp8m$cnj$1@nnrp1.deja.com>#1/1

Yes, with clever use of DECODEs. Use the FROM and WHERE clause to deliver the 'lowest common denominator', and then use the DECODEs to determine whether of not to display the value of that column for that row.

HTH,
Michael J. Ort

In article <8dffu7$1pe$1_at_nnrp1.deja.com>, li <vsp_at_us.net> wrote:
> Hi,
>
> This is rather an SQL question, I guess:
>
> Can I build a view from 3 tables having a different WHERE condition
for
> each non-key column without creating intermediary views?
>
> Thanks for helping,
>
> vsp
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 17 2000 - 00:00:00 CDT