query problem

Is there anyone can solve my problem with query...i have two table as below:-

Table employee

ID position name

A Manager AA
B Clerk BB
c Clerk CC

ID approval status

B A New
C New

Here i want to query out name of applyer B And Approval A at the same time from employee table..........is it possible.can anyone help me.

Thanks in advance

select e.name from employee as e left join leave as l on e.id=l.id where l.status='New'

this will select all "New" status ..

hope it helps.

i wish i wasnt so ignorent with databases 🙁, oh well, i guess i know enough for the first day. 😛...

joins are tricky to learn, but definately something to make a point to learn early on.

select e1.name as applyer, e2.name as approval
  from employee e1 join leave on e1.id = leave.id 
   inner join employee e2 on leave.approval = e2.id