I'm designing a database for our new Application and have some
problems with the following:
We have a table Jobs in which we store all kind of Jobs.
Looks like this:
easy so far :)
The problem is we also want to keep track which of the Jobs are
related or almost the same.
If we have the following jobs:
2 auxiliary worker painter
4 auxiliary worker plasterer
6 auxiliary worker electrician
There will be 2 logical "groups":
1, 2, 3, 4
If I query for "plasterer" I should get the following result:
- auxiliary worker painter
- auxiliary worker plasterer
If I query for "auxiliary worker electrician" I should get this:
- auxiliary worker electrician
What is the easiest way to design this?
I thought about this the whole morning but couldn't get a solution.
I hope somebody on this list can point me in the right direction.