Skip to main content
A
Anonymous
February 27, 2009
Question

Coldfusion and intersection of two queries

  • February 27, 2009
  • 3 replies
  • 892 views
Hello Everyone,

I have two select queries and I was trying to use INTERSECT operator between those two queries but using query of queries. I am getting the following error:

Query Of Queries syntax error.
Encountered "INTERSECT

But the same thing works for union and union all. Can anyone tell me if we can use INTERSECT in query of queries?

Thanks
    This topic has been closed for replies.

    3 replies

    -
    -__cfSearching__-
    Inspiring
    February 27, 2009
    Could you not do the same thing with a regular JOIN or two? It is not as elegant as intersect, but should achieve the same effect.
    A
    Anonymous
    February 27, 2009
    okk...is there any alternative?
    -
    -__cfSearching__-
    Inspiring
    February 27, 2009
    > Can anyone tell me if we can use INTERSECT in query of queries?

    QoQ support a very limited set of sql operations. They do not support INTERSECT.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices