Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    12

    Unanswered: Iterate through a table to use with WHERE

    If I have a table that has a list of IDs, how can I run a query that has a WHERE clause that can iterate through the first table?

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Wow. That is one of the more poorly presented posts that I have seen on this forum.

    Come on Darkmatter5, give us a bit more information.

    You mention a "first table," which implies there is more than one table, but nothing in you question seems to reference more than one table.

    What are you talking about ???
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  3. #3
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Maybe you should paste an example of what you "have" and what you want this query to return.

    I too have no idea what is being requested.
    Last edited by papadi; 10-25-12 at 16:38.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Maybe it's supposed to be a zen koan like "what is the sound of one hand clapping?"

    As to the original question, though, there are one or two good resources out there to help.

Posting Permissions

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