Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
If I understand correctly your job schedule table needs to be 1 record per "employee assigned" per job per week rather than having multiple "employee assigned" values in the same record. Then your list of available employees would be all where there is no record that contains that employee.
Hope this helps. BTW, I used to line in Gainesville back in the 80's. Worked in the oilfields.
To be honest I find this website almost unusable (i,.e just can't figure it out) so if you respond I will try to return the favor but I would not guarantee it.
John
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement