With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have a MySql database with two tables:
1. The table "Personalliste" list all employees. Each employee is identified with a unique number (column "Ansattnr").
2. The table "Ark4" contain the work schedule of all employees. The employees are identified by the column "Ansattnr".
I need a simple script to check if there is any employees listed in the work schedule table (Ark4) thats not listed in the employee list (Personalliste) and print (on screen) a list of the missing employee numbers (Ansattnr).
Sample tables are enclosed.
Sign in or Register to see more