Re: xpost from triggers: create before insert, mysqlworkbench: the object's DDL contains syntax error

[Peter Brawley]

Missing parens ...

set new.person_join_date = (
  select birth_date
  from people
  where people_id=new.people_people_id
);

If that errors, let's see the Show Create table results for the two tables.