How to Join two tables without common column

[nive63]

Hi Team 

I have two tables with different set of columns and both tables do not have common columns to create database view and do left join. Could you please suggest how can i achieve this

[freddyjm]

Hello nive63,

If you may post an example of your 2 tables, showing the relevant columns and some values, and also an example of the result view you are expecting I think it will hepl the community to better visualize your issue. 

Regards,

Freddy