****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Employee Profile Subreport.rpt
****************************************************************************************************

-------------------------------------------------- Main Body --------------------------------------------------


SELECT 
	Employee.[Employee ID]
	,Employee.[Last Name]
	,Employee.[First Name]
	,Employee.Position
	,Employee.[Birth Date]
	,Employee.[Home Phone]
	,Employee.Extension
	,Employee.Photo
	,Employee.Notes
	,Employee_Addresses.Region -- In unused formula
	,Employee_Addresses.City -- In unused formula
FROM
	Employee
		INNER JOIN [Employee Addresses] Employee_Addresses ON Employee.[Employee ID] = Employee_Addresses.[Employee ID]
ORDER BY
	[@first letter] ASC -- Group #1
	,@name ASC -- Group #2

-------------------------------------------------- EmployeeAddress --------------------------------------------------

-- Query(s)

SELECT 
	*
FROM
	Employee Addresses
WHERE
	Employee_Addresses.[Employee ID]={?EmployeeID}