Question

I am trying to do a insert into select statement that only gets the first 10 characters of a field.  I am inserting this into a table that already has data.  Im getting an error can't insert  where primary is null but I  have a where clause comparing primaries.

Insert into demographics(name)

Select substr(usr_system_name, 0,10)

From user_permissions

where demographics.dem_primary_key = user_permissions.usr_primary_key