I am trying to return the values on all records in the SQL query, but it is only returning one record - there should be many, many more. I know that I am doing an inner join - is this not correct? How would I write this to show all records in the two tables using the fields in my query:
SELECT
Employer.CompName AS EmployerName,
Employer.EmailADDR AS EmployerEmail,
CCEmployerHold.FirstName AS FirstName,
CCEmployerHold.SurName AS LastName,
CCEmployerHold.EmailAddr AS CandidateEmail
FROM Employer
INNER JOIN CCEmployerHold ON Employer.EmployerID = CCEmployerHold.holdby
ORDER BY Employer.CompName
Thank for your help.
Mike