without using joins

Hi @all

I am having 2 tables in database and I want to connect that both the without using  join  ,so how can I do that, as reference key is not assign in any of the tables. And I am not having permission to do any change in the database module.

And then I need to connect it to the table widget.

Hey there @Rohan Roy!

What type of tables or entities they are, what relationship do they have? Why you cannot use joins to connect them? What permissions do you have? And what do you want to accomplish with these 2 tables/entities? What do you want to show on the table widget with those entities?

Are you working in reactive or traditional?

Don't get me wrong, to "us" to give you a proper answer maybe this needs to be answered first.

Thank you, Rohan! :)

Kind Regards,

Márcio

Hi Rohan,

can you send a print of both tables and fields? Also explain a possible connection between both?

Regards

Champion

Hi Rohan,
Despite the question as mentioned above is not clear for folks & me as well :)

Here's something I would suggest :

- You can have a new entity i.e a Junction entity which will maintain a mapping of these 2 entities.

Aside from these, I don't see any way to join table records on runtime unless there's something you already know about how they are related.


Hi rohan,

Can you please explain.. Exactly what you are expecting with real time example.

Please provide any snap if you have.

Kind Regards,

Ajit kurane.


Hello Rohan,

I am not sure if you are asking this in reference to OutSystems or you have general SQL query about this scenario. If it's general SQL, you can go through with following links. It will help you to join and pull the data from 2 different tables without having common column into both of them.

https://intellipaat.com/community/47938/how-to-join-two-tables-without-common-column-in-sql

https://learnsql.com/blog/join-tables-without-common-column/

Thanks & Kind Regards,

Sachin

hii rohan

you can create a third entity (Junction entity) and can have reference variable from both the other entities. now you can have data from both the tables without using joins but it would be more appropriate to add some details about the entities and the relationship you want it to have.  happy learning!!

regard, 

mukul singh nathawat.

mvp_badge
MVP

Hi Rohan,

Not sure about your question but without join if you select data of both tables you can use Advance Sql and use UNION clause for it with no of column same.

https://www.w3schools.com/sql/sql_union.asp


Hope this will help you.

Regards

Rahul

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.