Results 1 to 2 of 2

Thread: SQL statement

  1. Dec 13th, 2004, 02:55 PM #1
    richsmith
    richsmith is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2001
    Posts
    364

    Resolved SQL statement

    hi,
    ok i have a database in access and i need an sql statement, that does something like this:

    Select * from categories where categoryID = 6, 8, 35, 36, 123 etc

    is this possible, i dont really know how to do it.
    Please help

    many thanks
    Last edited by richsmith; Dec 14th, 2004 at 07:57 AM.
    Richard <><
    Reply With Quote Reply With Quote
  2. Dec 13th, 2004, 02:59 PM #2
    mudfish
    mudfish is offline
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353

    Re: SQL statement

    Select * from categories where categoryID in ( 6, 8, 35, 36, 123 )
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width