SQL statement to join data from 2 different tables in ICM

[brienstepp1]

I need to look up data from 2 different tables to match the person ID from the PersonID table with the peripheral number from the agent table.  

Here is my query which works fine in SSMS

SELECT t_Person.LoginName, Agent.PeripheralNumber
FROM Agent INNER JOIN
t_Person ON Agent.PersonID = t_Person.PersonID
WHERE t_Person.LoginName = 'bstepp'

this query returns my peripheral number which I need to send to a queue to agent node.

I am getting the login name from CVP on PV4 and in ICM need to translate that to my peripheral number to ring the agent phone.

What is the best way to do this?  DBLookup node?  Set PV?  

[david.macias]

So it's not supported to query the UCCE DB directly, but I've seen it done. An idea world you would export this daily/weekly to a 3rd party DB and then do a dip to that via CVP or ICM DBLookup.

david