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

Reply via email to