Compare two fields from two tables and get the value from another table

[Anonymous]

Hi All,

Need one help.

Requirement : We have two columns from two different tables like the example given below.

If i will serach for ABCDS in column 1 ,then it should return all the values in column2.

So we need to compare the two columns from table1 and retrieve another value from  table2 .

Example : TABLE1:   column1                      column2

                                ABCDS                      ABCDS 0.5GHND

                                                                  ABCDS 0.1GHNDgs

              TABLE 2 : value

                                20

Kindly suggest for this.

[its_anandrjs]

Try with

TABLE1: 

Load

column1,

column2,

If(column1 = Left(column2,5),1,0) as CompareFields

From Source;

Bu this you get on Field with data 1 and 0 1 means that row is compared

And what is the use of second table let me know do you have any common field in table 2

Regards

Anand

[Anonymous]

Sorry,,Just a small correction

Column 1 is from TABLE 1 and Column 2 is from TABLE 2.

And Value is from another table TABLE 3 and there is no common filed in TABLE 3.