Hi,

I have two tables as follows

Table1
Field1   Field2
1        500   
2        600
3        300
4        400
5        200

Table2
Field1
1
3
5

The value in table one field1, contain values for table2 field1.

Now I want to compare Table2 field1 with Table1 Field1, if it return true, then print the corresponding value from table1 field2. If this is false though, to skip the record and continue searching for the second record.

So basically I want my end results (report) to be:

Table2.field1        Table1.field2
1                      500                         
3                      300
5                      200

Can anyone help please.

Thanks.