Lookup similar in SQL SERVER 2008, no R2 for MultipleDataSet

Jun 21 2016 6:55 PM
I have the following problem:
I have a tablix 1 with a dataset, which has code person, name, city code.
I have another dataset2 which query dataset1 code and this brings the name of the city.
Is this possible? I clarified SQL SERVER 2008 R2 not for lookup function. Something similar?