lekhanhvinh 0 Newbie Poster

I have 2 databases on my computer, managed in the same SQL Management Studio - named DATABASE1 and DATABASE2. The two databases are different except they have 1 table is the same, this table is called Employee

Because this the content of this table should be the same, how could I make the Employee in DATABASE1 change if I change the Employee in the DATABASE2 ? Employee in DATABASE1 is like an image of Employee in DATABASE2

For example,
in Employee in DATABASE1:
John
Long
Kerry

in Employee in DATABASE2:
John
Long
Kerry

Now, I delete John from Employee in DATABASE2, the content
in Employee in DATABASE1:
Long
Kerry

really appreciate any help or suggestion

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.