User Profile

Collapse

Profile Sidebar

Collapse
Mook Johnson
Mook Johnson
Last Activity: Apr 18 '12, 07:01 PM
Joined: Feb 23 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mook Johnson
    replied to I really need help with this subquery
    in Oracle
    Hey, thanks for the reply. I am still having problems with this. I am pretty bad when it comes to database. This is what I have now; Not really sure if I am on the right track but it returns 54 rows.. so I know it's incorrect.

    Code:
    SELECT authors.au_id,authors.fname,authors.lname,titles.title_id
   FROM authors left join author_titles ON authors.au_id = author_titles.au_id,titles
     WHERE pub_id IN(
	 SELECT pub_id
    ...
    See more | Go to post
    Last edited by Rabbit; Feb 24 '12, 04:22 PM. Reason: Please use code tags when posting code.

      Leave a comment:

    • Mook Johnson
      started a topic I really need help with this subquery
      in Oracle

      I really need help with this subquery

      Hey I am really bad at databases and I am having problems writing this query.

      I have to write a subquery that lists the authors( au_id, fname and lname) and the title_Id for their books for authors that have books published by the publisher with the greatest sales. I have no idea how to do about doing this. I am horrible at sql queries. Please help. This is all I have :/

      Code:
      select authors.au_id,fname,lname,author_titles.title_id
      ...
      See more | Go to post
      Last edited by Rabbit; Feb 24 '12, 04:22 PM. Reason: Please use code tags when posting code.
      No activity results to display
      Show More
      Working...