Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    144

    Post Unanswered: Select In Select

    hi
    is it possible in MySql to SELECT in the result of another SELECT?
    somethin like this statement:
    Code:
    SELECT * FROM Cars WHERE car_type_id IN
    (
    SELECT car_type_id FROM Car_Types
    )

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    yes but only if you are on version 4.1 or newer.

Posting Permissions

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