Skip to main content
B
balumohan
Inspiring
March 2, 2009
Answered

Common records from two recordset

  • March 2, 2009
  • 1 reply
  • 487 views
Hi All,
I have a problem.Consider two recordsets A and B. I want common records that are present in both A and B . Is there any easy way to do this? Please help me out!!!!
    This topic has been closed for replies.
    Correct answer Newsgroup_User
    Query of Queries (QoQ):

    <cfquery name="myQoQ" DBTYPE="query">
    SELECT *
    FROM query1, query2
    WHERE query1.somecolumn = query2.somecolumn
    </cfquery>

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/

    1 reply

    N
    Newsgroup_UserCorrect answer
    Inspiring
    March 2, 2009
    Query of Queries (QoQ):

    <cfquery name="myQoQ" DBTYPE="query">
    SELECT *
    FROM query1, query2
    WHERE query1.somecolumn = query2.somecolumn
    </cfquery>

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
    B
    balumohanAuthor
    Inspiring
    March 2, 2009
    Thank you very much!!!
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices