RSS Forums RSS

Oracle SQL Plus Joining

Please support our Oracle advertiser: Programming Forums
Reply
Posts: 3
Reputation: axxouk is an unknown quantity at this point 
Solved Threads: 0
axxouk axxouk is offline Offline
Newbie Poster

Oracle SQL Plus Joining

  #1  
Nov 29th, 2008
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)
Last edited by axxouk : Nov 29th, 2008 at 7:12 pm. Reason: Attaching more files
Attached Files
File Type: doc ERD DIAGRAM-.doc (35.5 KB, 3 views)
File Type: doc conceptual model.txt[1].doc (182.5 KB, 3 views)
File Type: doc entity relationship.txt[1].doc (202.5 KB, 3 views)
AddThis Social Bookmark Button
Reply With Quote  
Posts: 3,465
Reputation: peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold 
Solved Threads: 412
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Oracle SQL Plus Joining

  #2  
Nov 30th, 2008
And what you expect us to do with this?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote  
Posts: 1,858
Reputation: debasisdas is on a distinguished road 
Solved Threads: 113
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Posting Virtuoso

Re: Oracle SQL Plus Joining

  #3  
Dec 1st, 2008
what have you tried till date.

i do not open all the attachments that i come across in net .
Share your Knowledge.
Reply With Quote  
Posts: 3
Reputation: axxouk is an unknown quantity at this point 
Solved Threads: 0
axxouk axxouk is offline Offline
Newbie Poster

Re: Oracle SQL Plus Joining

  #4  
Dec 2nd, 2008
I need help with joing two tables to get the results which is the author name and what booked he borrowed
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Views: 1138 | Replies: 3 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 3:01 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC