SQL query to get descriptions from selection lists

SOLVED

Hello,

Does anybody know which table are the descriptions of the codes for selection lists kept in? I am writing an SQL query to get some information for a report that is going to be outside of Sage CRM

For example I have this lookup table setup in the communication table:

In the communication record, the system only keeps the code.

How do I get to the description mapping of "Blog" for this code?

Please and thank you!

Prabha

Parents Reply Children