Newbie SQL Question

From: Uzmati29 <uzmati29_at_aol.com>
Date: 12 Mar 2000 23:36:17 GMT
Message-ID: <20000312183617.02585.00001733@ng-fq1.aol.com>

Hi,

I am new to oracle and need some help with SQL statements. I am using SQL + 3.3.

How would I perform this querry?

---

For mechanics, list the employee ID number, last names, salary, years of experience, and the aircraft that they are certified to repair?

---

The tables involved are

Employee (E_ID; Lname; Fname; MI; Address; DOH; Salary; Base; Category; Year_of_Birth)

Mech-attrib (E_ID, Can_Repair)

---

My main problem involves the years of experience. How do I use the date of hire (DOH) with the sysdate function to calculate an employee's years of experience?

thanks Received on Sun Mar 12 2000 - 17:36:17 CST