I've been asked to create a proof of concept for a new database tool we need to develop, combining various existing databases.
It’s been awhile since I’ve touched any database work and I’m a little unsure how to go about it.
Let me explain the problem...the analogy I’m using here isn’t perfect but it fits to a degree.
We have two existing tables that must be combined. we have employees and their assigned projects (many to many)
And we have another table with projects and the tasks that decompose then (many to many once more)
Is it possible to create a query that joins the two tables on project?
So that we basically end up with a table with employees | project | task