Professional Web Applications Themes

Use results from query to search a different table - Coldfusion Database Access

Hello, I have a table named inquiries. It contains 1,000 records and continues to grow. I've been asked to take the firstName, and lastName from each record and use them as search criteria against another database that contains about 6,000 records. So I'm faced with the delemma of running a 1,000 searches at any given time... I haven't a clue as how to begin.. Any help or direction would be greatly appreciated. Thanks, Bob...

  1. #1

    Default Use results from query to search a different table

    Hello, I have a table named inquiries. It contains 1,000 records and continues
    to grow. I've been asked to take the firstName, and lastName from each record
    and use them as search criteria against another database that contains about
    6,000 records. So I'm faced with the delemma of running a 1,000 searches at any
    given time... I haven't a clue as how to begin.. Any help or direction would
    be greatly appreciated. Thanks, Bob

    bob2cam Guest

  2. #2

    Default Re: Use results from query to search a different table

    Will this work?

    SELECT *
    FROM FirstTable, SecondTable
    WHERE SecondTable.FirstName = FirstTable.FirstName
    AND SecondTable.LastName = FirstTable.LastName

    Dave Morris

    BigDMorris Guest

Similar Threads

  1. Query results don't display properly in results table.IGNORE PREVIOUS
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 24th, 07:28 PM
  2. Query results don't display properly in results table.
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 24th, 07:17 PM
  3. Dinamt Table, cannot export sql query results to excel! Please help
    By IluDeR in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 21st, 11:16 AM
  4. Display query results in iframe not a table
    By Earthworm Jim in forum ASP Database
    Replies: 0
    Last Post: November 18th, 02:04 PM
  5. Replies: 0
    Last Post: July 17th, 07:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139