Re: sql trouble

anonymous.coward.01@xxxxxxxxx wrote: 
is there a way to move the color of the shapes to the attribute
table (by creating a new attribute for every color) and then
associating this new attribute to every element of that shape?

Based on what I've read, MS SQL Server and JET (MS Access) SQL languages each have their own syntax to support a ulti-table UPDATE statements, though they each have different syntax to achieve this. And it's not standard SQL, for what it's worth.

MS SQL Server example:

  UPDATE table1
  SET field1 = t2.field2
  FROM table2 t2, table1 t1
  WHERE t2.pk = t1.fk

JET (MS Access) example:

  UPDATE table1 t1
    INNER JOIN table2 t2 ON t1.fk = t2.pk
  SET t1.field1 = t2.field2

See also:
http://groups.google.com/group/microsoft.public.access/browse_thread/thread/b0c764770735b116

Regards,
Bill K.
.