Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Niskayuna, NY
    Posts
    3

    Unanswered: Whats wrong with this SQL script

    select entityid, name, proptype, propsubtype from entity
    where entityid LIKE '%IV%'
    where proptype is null

    If I take out one or the other where statements it works if I leave them both in. it errors out

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Whats wrong with this SQL script

    Originally posted by ptbarnum
    select entityid, name, proptype, propsubtype from entity
    where entityid LIKE '%IV%'
    where proptype is null

    If I take out one or the other where statements it works if I leave them both in. it errors out
    Why do you use only two 'where'? Try add more...

    You cannot have more than one 'where' in select. Use 'and' instead of second 'where'.

  3. #3
    Join Date
    Sep 2003
    Location
    Niskayuna, NY
    Posts
    3
    Thanks

Posting Permissions

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