Read display value of a reference field
Gets related record(s) from a reference field. You need to know the referenced table name for that field, then query by sys_id (Primary Key).
--STEP#1 returns incident number and related company (sys_id)
SELECT number,company FROM incident
--STEP#2 find related table for company field
select name,reference from get_table_columns WITH(TableName='incident') order by 1
--STEP#3 query related table with sys_id returned in step#1
select sys_id, name from core_company where sys_id='31bea3d53790200044e0bfc8bcbe5dec'