SELECT
Staff.V004 as 'First Name',
Staff.V005 as 'Last Name',
Staff.V006 as 'Email',
Company.V001 as 'Company Name',
Company.V002 as 'Address',
Company.V003 as 'Phone Number'
FROM (SELECT * FROM [Record] Where TableId = (SELECT [TableID] from [Table] where TableName = 'Staff')) as Staff
INNER JOIN (SELECT * FROM [Record] Where TableID = (SELECT [TableID] from [Table] where TableName = 'Company')) as Company
ON Staff.CompanyID = Company.RecordID