troubleshooting Question

How to join/merge/union 2 tables so that new rows from one will be available in the other

Avatar of Steve Jennings
Steve Jennings asked on
MySQL Server
3 Comments1 Solution20 ViewsLast Modified:
I have a table of devices:

NET_TABLE: vendor - model - location - name - contract - owner (plus about 30 more columns)

The ops team copies that table removes some columns and creates more columns:

OPS_TABLE: vendor - model - location - name - notes - engineer - customer (plus about 40 more columns)

Whenever I add a new device (row) the ops team has to copy the new table and go thru a cumbersome process to keep their data.

This seems really inefficient. I don't really want to populate my table with their columns.

I'm thinking there must be a way to "union" or "join" my table with their table to pick up only new "vendor - model - location - name" rows, but I can't figure out the syntax to do it.

"union" seems to want a matching number of columns, and "join" seems only to find commonalities.

I can't seem to wrap my head around how to solve this, but it seems like a really simple problem.

SteveJ
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros