Sam Summers
Registered User.
- Local time
- Today, 15:55
- Joined
- Sep 17, 2001
- Messages
- 939
Hi guys,
They just stump me! Sometimes i get them right and others just seem impossible?
All i want to do is to display all employees even the ones with the "JobID" field and "JobName" field blank but can i get this to work.................
____________________________________________________________
SELECT Employee.EmployeeID, Employee.FirstName, Employee.Surname, Employee.National, Employee.Contract, Employee.RopeAccess, Employee.Level, Employee.MobDate, Employee.DeMobDate, Employee.JobID, Job.JobName
FROM Employee
INNER JOIN (Job INNER JOIN EmpJob ON Job.JobID = EmpJob.JobID) ON Employee.EmployeeID = EmpJob.EmployeeID
WHERE (((Employee.JobID) Is Not Null)) OR (((Employee.JobID) Is Null))
ORDER BY Employee.FirstName;
_______________________________________________________________
A lot of thanks in advance if someone can a) tell me what i am doing wrong?
and b) point me in the right direction?
They just stump me! Sometimes i get them right and others just seem impossible?
All i want to do is to display all employees even the ones with the "JobID" field and "JobName" field blank but can i get this to work.................
____________________________________________________________
SELECT Employee.EmployeeID, Employee.FirstName, Employee.Surname, Employee.National, Employee.Contract, Employee.RopeAccess, Employee.Level, Employee.MobDate, Employee.DeMobDate, Employee.JobID, Job.JobName
FROM Employee
INNER JOIN (Job INNER JOIN EmpJob ON Job.JobID = EmpJob.JobID) ON Employee.EmployeeID = EmpJob.EmployeeID
WHERE (((Employee.JobID) Is Not Null)) OR (((Employee.JobID) Is Null))
ORDER BY Employee.FirstName;
_______________________________________________________________
A lot of thanks in advance if someone can a) tell me what i am doing wrong?
and b) point me in the right direction?
