Penny Arcade Forums› Help / Advice Forum
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

What will be the result of the query below?

sonal78sonal78 Registered User new member
in Help / Advice Forum
SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)

Posts

  • Options
    SixSix Caches Tweets in the mainframe cyberhex Registered User regular
    edited June 2016
    It will select the items in the runners table whose winner_id does not appear in the races table. Presumably it will tell you all the runners who have not won a race.

    Six on
    can you feel the struggle within?
  • Options
    schussschuss Registered User regular
    Tough to tell without knowing the table/database structure.

Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum