Cartesian product from sql table and excel file

[Anonymous]

hello,

i need to do a cartesian product from an excel file and from a sql table.

¿could you show me how can it be done or where can i see it how can it be done?

thank you

[effinty2112]

Hi Pablo,

To obtain the cartesian product of two table then perform an outer join. If you load your data from SQL into table A then

Outer Join([Table A)

Load

.

.

.

From .....xls

Regards

Andrew