Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

join table not having common columns in oracle

 
rekha singh
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic