hi

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

Table Leave
-----------
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




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to