Find Name of USER in Moss 2007 UserDatabase Table

How to find Name of user in Moss 2007 Userdatabase Table ?

Solutions is Here :

Select
(Select tp_Title As UserName from UserInfo where UserInfo.tp_ID=UserData. and tp_siteID='Site ID Add Here') As UserName
From UserData
Where tp_ListId like 'List ID of List'

Example

Select
(Select tp_Title from UserInfo where UserInfo.tp_ID=UserData.int10 and tp_siteID='00BAC987-FR94-000A-8760-9H316C1F3974') As UserName
From UserData
Where tp_ListId like '000efcc7-9092-4346-11a5-ae521425ffba'

Cheers
Pritesh Gandhi

	When you are waiting for the bus and someone asks, "Has the bus come yet?". If the bus came would I be standing here?
From Pritesh Public Profile