I really should have started with '0, field2' in the example below -
assuming field 1 is the primary key..
If you have an auto incrementing primary key 'id' as the first field
in both tables...
INSERT INTO tableA SELECT 0, field1, field2, field3, etc... FROM tableB
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
