Date |Wed, 08 Aug 2001 07:02:09 +0000
>From |"saraswathy saras" <[EMAIL PROTECTED]>
Hello!
SS> hai
SS> do anyone know how to join table in DBASE?
SS> The situation :-
SS> table 1
SS> ---------
SS> EM_id
SS> EM_gender
SS> table 2
SS> ---------
SS> EN_id
SS> EN_name
SS> The question is how to select all field from table1 and EN_name from table2
SS> at one query? .The EM_id and EN_id is same.Is that any idea.
SS> please help me.
SS> thanks in advance.
You can use two tables in one SELECT queries.
SELECT * from table1,table2 where table1.EM_id = table2.EM_id
for example
___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
---------------------------------------------------------------------
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
