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" <titi@discussions.microsoft.com> wrote in message
news:D75B5662-6D71-48AC-A1F5-C0230E109AF1@microsoft.com...
>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