join table not having common columns in oracle

[rekha singh]

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]

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?