I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee.
first the employee is added to the database and then the job detils are added to the database
how do i get a query for all the employee who that the EmpStatus == 'Active' and the employees that the job details are not updated to the database
apprecite a reply