Append Table as new - different column Types with same column name?

Hi All, 

So I came accross this strange behaviour when trying to append a table and then merging this table with another query.

Table 1

Column 1 Type Text

Column 2 Type Any

Column 3 Type Whole Number

Table 2

Column 1 Type Integer

Column 2 Type Any

Column 3 Type Whole Number

Rsults in following Append:

Column 1 Type Any - which makes sense because I append two different column Types

Column 2 Type Any

Column 3 Type Whole Number

Then I merge with an left outer join with a table that also has column 1 but Type Text.

When I then look at the result of the merge - the values from Table 1 that have column 1 Type Text populate properly while all of the other values in the append table column 1 coming from table 2 with type integer are omitted from the merge. 

Is this intended behaviour?

M