hugh200 post(s) |
Thank you, that clarifies a lot but I am still being dense. Seems like both [xydata] and [xyzdata] are tables: imported xydata.csv imported xyzdata.csv "id","x","y" "id","x","y","z" 1,44,12 1,3,0,0 2,64,34 2,71,32,2236 3,42,16 3,71,40,2804 4,53,28 4,25,14,362 5,53,24 5,78,30,2340 6,70,29 6,91,54,4960 7,32,21 7,25,20,488 8,30,8 8,82,43,3526 9,34,10 9,53,20,1086 10,65,36 10,0,0,0 and both get indexed like so and column z added to [xydata] --SQL9 ALTER TABLE [xydata] (ADD [mfd_id] int64); ALTER TABLE [xydata] (ADD INDEX mfd_id_x BTREE (mfd_id)); ALTER TABLE [xyzdata] (ADD [mfd_id] int64); ALTER TABLE [xyzdata] (ADD INDEX mfd_id_x BTREE (mfd_id)); ALTER TABLE [xydata] (ADD INDEX id_x BTREE (id)); ALTER TABLE [xyzdata] (ADD INDEX id_x BTREE (id)); ALTER TABLE [xydata] (ADD [z] int32); INTO works to create a new table --SQL9 SELECT [xydata].[id], [xydata].[x], [xydata].[y], [xyzdata].[z] INTO [xyzdata2] FROM [xyzdata] INNER JOIN [xydata] ON [xydata].[id] = [xyzdata].[id] but this does not work as UPDATE . . . SET because "Expression should return table with single field". --SQL9 UPDATE [xydata] SET [z] = ( SELECT [xydata].[id], [xydata].[x], [xydata].[y], [xyzdata].[z] INTO [xyzdata2] FROM [xyzdata] INNER JOIN [xydata] ON [xydata].[id] = [xyzdata].[id] ); There is still something really basic I am not understanding. Thank you for helping me try Attachments: xyzM9.mxb
|