Question choose the table who will be use in first in a cross join

Hi,
i want in a join make a cross join, but I want a table in first but i did'nt do it. I try to use in properties on the tables , in advanced 'order', but it s not working, i try to put on the mapping my main table first and my second one but nothing work.

The code is
select ...
from table2 CROSS JOIN table 1

and i want the opposit
select ...
from table1 CROSS JOIN table 2

you can see in attachement my mapping

thank you for your help

Alexa

Hi,

You can change this in the properties of the Join, with changing the 'Left Part' and 'Right Part' in the order you want it to be in the query.
It should resolve your problem.

Hi,
no in fact the two tables are independant
One give her data in the final table and the other just help to fill one variable DAT_DONN in the final table. So I can't make left or right my join between this table tell nonsense.
So what can i do?

Thanks

Sorry if I was not clear.
You have to reverse the left part and right part in the properties, but keep the cross Join Type.

For example :
Left part : table1
Right part : table2
Becomes
Left part : table2
Right part : table1

Join Type : Cross

Hi,

Thanks it's working

Bye