Results 1 to 4 of 4

Thread: Query Quandry-

  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Quandry-

    Here

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Quandry-

    You use a subquery. Roughly, you'd do it like this:

    SELECT tblPlant.PlantID, tblPlant.PlantName FROM tblPlant WHERE Not tblPlant.PlantID In (SELECT DISTINCT tblPic.PlantID FROM tblPic)
    Charlotte

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Quandry-

    Wow! Never even saw a subquery before. I knew there was an easy way somewhere....thanks
    Tim

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Quandry-

    You're welcome. You can use subqueries in all kinds of ways, so have fun!
    Charlotte

Posting Permissions

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