Are you looking for something like this?
select distinct TOP 1000 wtp.ProfileID
, wtp.ProfileName
, wtp.WRC_ProfileID
, wtp.TimeZoneID
, wtd.DataSourceID
, wtd.DCSID
, wtd.Name
From wt_profile wtp
Inner Join wt_ProfileDataSource On wtp.WRC_ProfileID = wt_ProfileDataSource.ProfileID
Inner Join...