#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    france
    Posts
    35
    Rep Power
    14
    Hi there.

    I'd like to know why
    SELECT ... FROM ... WHERE variable IN (SELECT ... FROM ... WHERE ...)
    doesn't work, although it works if I write the result of the second query as IN arguments, like
    SELECT ... FROM ... WHERE variable IN ('variable1', variable2', 'variable3', ...)

    Thanks

    -
    J0f
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    35
    Rep Power
    14
    MySQL doesn't do subselects...

    HTH
    marty

Similar Threads

  1. Requesting help on READTEXT statement
    By hdokes in forum MS SQL Development
    Replies: 1
    Last Post: March 19th, 2004, 08:53 AM
  2. Question about the WHERE statement
    By layz d in forum MS SQL Development
    Replies: 5
    Last Post: January 28th, 2004, 11:58 AM
  3. how can i put an IF statement inside a WHILE statement?
    By Jarrett Green in forum Perl Programming
    Replies: 4
    Last Post: December 22nd, 2003, 10:05 PM
  4. Replies: 7
    Last Post: October 10th, 2003, 08:13 AM
  5. selct statement help
    By p_murugappan in forum PHP Development
    Replies: 7
    Last Post: September 25th, 2003, 10:51 AM

IMN logo majestic logo threadwatch logo seochat tools logo