Hi, how do I do this? For example:
Table 1:
id first_name last_name age
1 cruise tom 35
2 cage nicholas 35
Table 2:
id first_name last_name status
1 willis bruise married
2 connery sean married
3 hurley liz single
New Table
id first_name last_name status age
1 willis bruise married NULL
2 connery sean married NULL
3 hurley liz single NULL
4 cruise tom NULL 35
5 cage nicholas NULL 35
So how do I get the \\"New Table\\" which is Table 1 copied right under existing Table 2?
One solution might be: Add new field \\"age\\" at end (obviously). Do a sql statement that selects all rows from Table 1. For each and every selected row, do an \\"insert into\\" statement into \\"New Table\\".
I\\'m not a professional programmer, so if above solution is correct, can someone please provide enough real code so that I can get a good idea how to make it work, or any better solutions? Thanx for any help in advance 😃
