Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to Join two tables without common column

nive63
Kilo Contributor

‎08-31-2023 12:34 PM - edited ‎08-31-2023 12:35 PM

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

0 Helpfuls
  • 1,050 Views
1 REPLY 1

freddyjm
Tera Contributor

‎09-01-2023 07:09 AM

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. 

 

Screenshot 2023-09-01 100655.jpg

 

 

 

 

 

 

 

Regards,

Freddy

0 Helpfuls