How to retrive data from two tables not having common column

try below code

Select * from

FROM B

JOIN A ON 1=1

0

use INNER JOIN with some always true conditon:

0

use join or view

0

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

0

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"?

0