Hi, can anybody tell me how can i select,update, delete the records from two table having same structure in the mysql.
For ex MainTable ------------------- id(int)| val (varchar) ------------------- 1 a 2 b 3 c ------------------- Duplicate Table ------------------- id (int) | val (varchar) ------------------- 1 d 5 e 6 f ------------------- I want result for id 1 like this ------------------- id (int) | val (varchar) ------------------- 1 a 1 d ------------------- Thanks in advance DK Dubey --------------------------------------------------------------------- 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