This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes join table not having common columns in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "join table not having common columns in oracle" Watch "join table not having common columns in oracle" New topic
Author

join table not having common columns in oracle

rekha singh
Greenhorn

Joined: May 28, 2013
Posts: 3
Hi,


How to join two table not having common columns

for example- student Table having columns :Roll no,Name,DOB,Address

and test Table having Columns :Test no,Description,Date of Test

How to join this two table in oracle eventhough there is no common column in this two tables?


Thanks in advance




chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1660
    
  14

Why do you think you should join two tables that have no apparent relationship? If there is some kind of logical link between the data in these tables, then that logical link will tell you how to join the tables. Right now I don't see any such link. Do you?


No more Blub for me, thank you, Vicar.
 
wood burning stoves
 
subject: join table not having common columns in oracle