Concatenate peculiarity

[#1]

Here is an odd one. If I use

[Data]:

Concatenate

Load *

Resident [Sample];

I get a completely different result to that if I use:

Concatenate([Data])

Load *

Resident [Sample];

Its as though the 1st statement applies some kind of Left Join principles to the [Data] table loaded in the script.?

Any ideas anyone?

Thanks

Moose