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..

Rafnas T P · Answer

try below code Select * from FROM B JOIN A ON 1=1

Daniel Jones · Answer

use INNER JOIN with some always true conditon: FROM table1 INNER JOIN table2 ON 1=1

Bikesh Srivastava · Answer

use join or view

Khaja Moizuddin · Answer

Select * from table b inner join table a on 1==1 try this.

Nitin Sontakke · Answer

It would helpful if you could share sample data with expected output. Or is this a an interview (theory) question? Did you try on 1 = 1 ? For (just as) an example: select * from b left outer join a on 1 = 1 In any case if there are no matching columns what is meaning of get data from table B based on table A?