"Martin Jeremic" <[EMAIL PROTECTED]> wrote:
> Can somebody tell me where i'm wrong ?
> 
> insert into table3 select * from table1 where RecNo = 12  ---> this
> works
> 
> insert into table3 select * from table2 where RecNo = 12  ---> Nothing
> Happens

Post to the list the output of:
DESCRIBE table1
SELECT * FROM table1 WHERE RecNo = 12
SHOW INDEX FROM table1

and the same for table2.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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

Reply via email to