Re: How to store a old company which become a new company or part of a group?

On August 5, 2020 10:58, ^Bart wrote:

> Hi Guys!
> 
> I need to do a db where I could store company's details and company's
> products but what happen when a company for example named "X" become a
> company named "Y"?
[snip]

See my 2020-02-25 reply to you in the comp.databases.mysql thread titled 
"Something like a FK but in the same table"
 (https://groups.google.com/d/msg/comp.databases.mysql/3ra_9uarsHU/oOEWBtjpCQAJ)
where I outline how to use a many-to-many table to hold company history.

HTH
-- 
Lew Pitcher
"In Skills, We Trust"