Oracle SQL Plus Joining

Question

axxouk 0 Newbie Poster

15 Years Ago

Author Table

INSERT INTO Author VALUES (12,'James Smith' );

Using join conditions
Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with vnd.ms-office files.

conceptual_model.txt[1]_.doc (182.5 KB)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with vnd.ms-office files.

entity_relationship.txt[1]_.doc (202.5 KB)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with msword files.

ERD_DIAGRAM-.doc (35.5 KB)

3 Contributors
3 Replies
232 Views
3 Days Discussion Span
Latest Post 15 Years Ago Latest Post by axxouk

peter_budo 2,532 Code tags enforcer

15 Years Ago

And what you expect us to do with this?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

debasisdas 580 Posting Genius Featured Poster · Answer 1 · 2008-12-02T00:55:01+00:00

what have you tried till date.

i do not open all the attachments that i come across in net .

axxouk 0 Newbie Poster · Answer 2 · 2008-12-03T00:35:15+00:00

I need help with joing two tables to get the results which is the author name and what booked he borrowed