Need help with SQL query involving a recursive query

Heres the 2 tables involved:
EMPLOYEE
Emp_Num
Emp_Name
Date_of_Birth
Salary
Bonus
Manager_Num

SALES_REP
Rep_Code
Telephone
Mobile_Phone
Email
Region

The question, "for all representatives in the North Connaught region, list
their name, total salary (including bonus), mobile phone number, email
address and manager name."

How do I work this??
The Emp_Num of an employee's manager is in the manager number field, so I
have to query the same table again. I have to do it in one query. It's a
question on a college exam paper.




.

Relevant Pages

  • Re: Need help with SQL query involving a recursive query
    ... > their name, total salary (including bonus), mobile phone number, ... > The Emp_Num of an employee's manager is in the manager number ... I have to do it in one query. ... Sample Data, EMPLOYEE_20051129_1: ...
    (microsoft.public.access.queries)
  • Re: Need help with SQL query involving a recursive query
    ... >> their name, total salary (including bonus), mobile phone number, ... >> The Emp_Num of an employee's manager is in the manager number ... I have to do it in one query. ... > Manager_Num cannot contain a Null and have a foreign key to Emp_Num ...
    (microsoft.public.access.queries)
  • Re: Passing parameter to query without using Enter Parameter window
    ... will do the filtering for you without having that parameter in the query. ... Dim strSQL As String, strTemp As String, strMgr As String ... ' Get list of manager IDs -- note: replace my generic table and field ...
    (microsoft.public.access.modulesdaovba)
  • Re: Export to excel in different tabs depending on criteria
    ... various data and export each filtered query to separate ... Dim strSQL As String, strTemp As String, strMgr As String ... ' *** code to set strSQL needs to be changed to conform to your ... ' Get list of manager IDs -- note: replace my generic table and field ...
    (microsoft.public.access.externaldata)
  • Re: OT: SQL
    ... said was a totally failed attempt to formalize and automate database ... query processing. ... create table Employees ... Manager and Employee Salaries. ...
    (sci.logic)