Hi.

I have to use a long, complicated "Where" clause in a SQL statement and
thought it would be better to break it up into 2 Selects but am not sure of
how to do it.

I'll make my example really simple - I want to select TextData (defined as
an Image in the SQL table) from a table Where TextData like '%ABC%' AND not
like '%DEF%'
AND not like '%GHI%' AND not like '%JKL%' etc.

Basically the question is how to code a Select within another Select where
the 2nd Select uses the results from the 1st Select.

Here's what I tried which doesn't work (I broke each piece down and they
work separately but not together):
Select ProviderName from (Select ProviderName from Provider where
PPONetworkID like '%9')
where ProviderName like '%EDEL%'

Any suggrstions will be greatly appreciated.
Rita

On Fri, 1 Apr 2005 10:09:03 -0800, RitaG wrote:

Hi Rita,

You're nearly there! You are right that you can use a query instead of a
table or view (this is called a derived query). The only thing you
forgot is to provide an alias for the derived table. Since it has no
name of it's own, it MUST have an alias - even if you never refer to it.

Select ProviderName from (Select ProviderName from Provider where
PPONetworkID like '%9') AS x
where ProviderName like '%EDEL%'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

I knew there was a way! Thanks so much Hugo.

"Hugo Kornelis" wrote: