Hello Dipali, 

You can use the Cross Join inside an Advance SQL Querry widget.

You will need however a valid structure to use in that Advanced SQL Querry.

In my testing I created these 2 tables :

and 

And then I created my Querry 

Result : 

Hope it helps!

Paulo Rosário

Hello Dipali,

Hope you're doing well.

That is indeed possible to perform in OutSystems, using an Aggregate.

You can check this documentation.

The last example (combine all records, ignore relationship) is what you pretend, meaning, a cross join :)

Basically, you just need to add 2 entities into your Aggregate without any join relation between them. You'll instantly have a warning in Service Studio for those entities saying that the cross join is being calculated. As an example:

Hope that this helps you!

Kind regards,

Rui Barradas

Hi,

Thank you Rui Barradas and Paulo Rosario.