Two Databases

[Ringers]

Hi All,

I need to compare a two columns from different databases, DB SSAT: ID and DB SNAP:CODE, both are VARCHAR.

I have setup two datasources with these DB's and written a basic select for each that pulls the column.

What is the best way to compare them and ask if they are the same?

Thanks

 

[Ringers]

I understand that term lookup function should do this, but haven't a hard time configuring it.

 

[Ringers]

solved, used a lookup function to compare the two different columns.