Results 1 to 4 of 4

Thread: SQLcourses2: SELECT Statement: RE2

  1. #1
    Join Date
    Aug 2011
    Posts
    6

    SQLcourses2: SELECT Statement: RE2

    http://www.sqlcourse2.com/select2.html

    When I use

    select * from items_ordered where items = 'Tent';

    for Review Exercise #2 (which is the right answer) it doesn't give me a list.

  2. #2
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    78
    Does it give you an error?

    Remove the single quotes before and after TENT.

  3. #3
    Join Date
    Aug 2011
    Posts
    6
    Quote Originally Posted by Steve R Jones View Post
    Does it give you an error?

    Remove the single quotes before and after TENT.
    I figured it out...

    item not items...

  4. #4
    Join Date
    Aug 2011
    Posts
    6
    This is a useless post...delete?

Posting Permissions

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