Results 1 to 2 of 2

Thread: simple sql question

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 1999
    Posts
    309

    simple sql question

    How do I create the sql query to collect info about the records with f.i. the following id's: 1,6,10 ?

    I now how to collect all of them or just one (id=1 f.i.) or al above six (id>6 f.i.). But how can I collect specific ones ?

  2. #2
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606
    ...WHERE id IN (1,2,3,4,5,6)

    or

    ...WHERE id NOT IN (1,2,3,4,5,6)

Posting Permissions

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



Click Here to Expand Forum to Full Width