Posted by orin on 04/12/06 17:10

Hi all,

I've seen mention that you can use nested subqueries down to as many
levels as you like but whenever I run the following:

select * from table1
where tab1ID in
(select tab1ID from table2 where tab2ID in
(select tab2ID from Table3 where Tab3ID=N))

I get the error "incorrect syntax near the keyword 'where'"

Can anyone confirm that sub-subqueries are possible? If so is the
syntax I'm using correct?

I'm running SQL 2000 through a Delphi 5 app.

Regards
Jon

• Next in forum: Re: Are sub-subqueries possible?
• Prev in forum: Re: Literal value with "IN" clause
• Thread view: Are sub-subqueries possible?

[Reply to this message]