my dog learned polymorphism*
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
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: 1615
    
  13

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
 
Similar Threads
save my application
Hibernate mapping
how to connect to MS-Access from jsp
table struture for storing hierarical data
Add Header names to my columns at JTable?