moving data in sql

So after searching around the web looking for code to get data from one table intop another I found this example posted on the mysl dev forum

mysql> INSERT INTO orders (customer_cust_id, orderdatetime, message, taxrate, shippingprice)
-> SELECT ‘1’, NOW(), null, taxrate, shippingprice FROM customer
-> WHERE cust_id=’1′;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0

So basicly use INSERT INTO ‘tablename’ SELECT * FROM ‘tablethatmatches’