How to retrive data from two tables not having common column

Question

 How to retrieve data from two tables which are not having common columns, How can I join them?

For example: 

 I want to get data from table "B" based on table "A" without any common column. Can I use User defined function to join them?

 

 

Thanks in advance..