SQL Join question

John Craig john at splash21.com
Sat Jun 21 11:59:16 EDT 2014

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

More information about the use-livecode mailing list