select 
	A.ComputerID,
	A.Value,
	B.Name,
	B.Value
from BES_COLUMN_HEADINGS A, 
	BES_COLUMN_HEADINGS B
where 
	A.ComputerID = B.ComputerID and
	A.Name = 'Computer Name' and
	A.Value like 'TINTIN%'