Re: [sqlite] Nested SELECTS using UNION and INTERSECT syntax problems....

sorka wrote: > I can't for the life of me figure this out. I'm trying to do a nested select > like this: > > SELECT x FROM (( UNION ) INTERSECT ( UNION > )) WHERE X= > > Each of the select a through d statements all return the same column x. If I > remove the inner parentheses, it executes just

[sqlite] Nested SELECTS using UNION and INTERSECT syntax problems....

I can't for the life of me figure this out. I'm trying to do a nested select like this: SELECT x FROM (( UNION ) INTERSECT ( UNION )) WHERE X= Each of the select a through d statements all return the same column x. If I remove the inner parentheses, it executes just fine but of course the