After Migration ,Join Issues in Coldfusion 8

We have sampe two tables test1 and test100 , Wehile joining both the tables thorugh id. We have two or more columns with same column names in this table. But the values are different.

SELECT  a.ReturnInstructions,b.ReturnInstructions

FROM TEST1 a, TEST100 b
Where  a.ComponentId = b.Id

The query was working fine in coldfusion 4.5 in bringing the different values of the same column name  in development.

But in coldfusion 8, It is not working like that. Its copying the first table column value to the Second column values.

Example:

Table name : Test1

ReturnInstructions         ComponentId

--------------------------------------------

A                                   1

B                                   2

C                                   3

Table name : Test100

ReturnInstructions          ID

-----------------------------------------

X                                   1

Y                                   2

Z                                   3

After joining two tables, we are gettting like below.

ReturnInstructions         ReturnInstructions        

--------------------------------------------

A                                   A

B                                   B

C                                   C

If we look for a solution .We can do an alias for both the columns. that we have to do for the whole application,. Its tedious job ..

can you please let us know. Why the above query was working fine in coldfuion 4.5 and not in coldfusion 8?