aspose file tools*
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 Spring in Action this week in the Spring 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: 1772
    
  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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: join table not having common columns in oracle