I have this same problem frequently.
I don't know why it works the way it does, but I have an alternate solution.

Make two separate querys on two sheets.
Then use the vlookup function on one of the sheets to get data from the
other sheet.
--
Carlos

"titi" wrote in message
...
I French, so Sorry for my english.

I use Excel 2002 (or 2003) and I want to join 2 files dbase.
Under MSQUERY when I want to join this 2 files, in the 3 options, only the
1
is possible.

Why ?

Thank You.

Thierry