AOR using SQL

Summary

Display AOR fields by Employee Number and Name

Content

HI All,

I hope someone can help me with a SQL.

I want to try and build a common query that we can use in our reports 

I have read through many posts regarding the AOR and I know that I need to build a query using SQL but all of the samples that I have seen show the AOR in  a column 

ie:

Person Number, Person Name, AOR Name, AOR Position, Responsibility Name, Responsibility Type

EMPNUMBER	PERSON_ID	AOR_FULL_NAME	AOR_POSITION	RESPONSIBILITY_NAME	RESPONSIBILITY_TYPE
941058	300000010676902	Mostowich, Christopher