Board index » delphi » Union problem with sub-query

Schup Herbert

Delphi Developer
Sat, 18 Jun 2005 03:41:14 GMT

Union problem with sub-query

Hi all

I have an SQL that works fine:

SELECT id FROM call
  UNION
  SELECT call_id as id FROM call_task

But when I want to use the same in a sub-Query, it doesn't understand
'UNION'

SELECT * FROM V_CALL WHERE id in
 (SELECT id FROM call
  UNION
  SELECT call_id as id FROM call_task)

Can you help me?

Herbert

 
Craig Stuntz [TeamB

Delphi Developer
Sat, 18 Jun 2005 04:09:01 GMT

Re:Union problem with sub-query


In article <3e10a...@newsgroups.borland.com>, hsch...@external.ch says...
Quote
> But when I want to use the same in a sub-Query, it doesn't understand
> 'UNION'

        No, you can't do this.

Quote
> SELECT * FROM V_CALL WHERE id in
>  (SELECT id FROM call
>   UNION
>   SELECT call_id as id FROM call_task)

SELECT * FROM V_CALL
WHERE
  (id in (SELECT id FROM call))
 OR
  (id in (SELECT call_id as id FROM call_task))

        -Craig

--
Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Other Threads

1. MSAccess Union query problem

2. SQL problem - joins plus sub query (Paradox7)

3. Problem Running An Insert Query With Sub-Select Statement

4. Update query with sub-query

5. sort a union, view of union

6. What is difference between UNION and UNION ALL

7. Queries' columns union

8. Parameterised queries and UNION clause

9. Parameterised query with a union returns no data?

10. Memo fields in select clause of union queries