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,
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

Hi,

Thanks it's working

Bye