On Tue, 21 May 2019, Michael Lewis wrote:
> For each row-
> Insert into organizations table if the record does not exist, returning ID.
> Insert into people using that ID.
Michael,
The org_id will not exist until I run the insert script.
> Else, load all the data with empty ID column on person table,then just
> update the person table afterward and drop the org name column.
Then I'll copy the org_id numbers to the appropriate row(s) in the people
table.
Thanks,
Rich