DBASE query question.

[rsaras]

hai 
     In mysql it can be done but do anyone know how to join  table in DBASE?

The situation :-

 table 1
 ---------
EM_id
EM_gender

table 2
---------
EN_id
EN_name

The question is how to select all field from table1 and EN_name from table2  at
one query? .The EM_id and  EN_id is same.Is that any idea.
please help me.  


thanks in advance.