Results 1 to 4 of 4
  1. #1
    Join Date
    May 2013
    Posts
    8

    Unanswered: another subquery

    Almost done.
    In this subquery, I need to list book titles that are published by the same publisher as THe Wok way to cook. I am getting no date found in my results, but that's wrong. Even if my query did work, I think that it is written to show this title though and not the rest of the titles by this publisher who published the book.
    Any suggestions? Thanks

    SELECT title FROM books JOIN publisher USING(pubid) WHERE title =ANY (SELECT title FROM books JOIN publisher USING(pubid) WHERE title = 'THe Wok Way to Cook');.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SELECT title 
    FROM   books 
    WHERE  pubid = (SELECT pubid 
                     FROM   books 
                     WHERE  title = 'THe Wok Way to Cook');
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2013
    Posts
    8
    Thanks! Now that I'm done with this lab, looks like I need to practice more subqueries!

  4. #4
    Join Date
    Feb 2013
    Posts
    5

    Im new to WebLogic Does anyone knows how to Deploy Application using WebLogi.Deploye

    to WebLogic Does anyone knows

Posting Permissions

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