This topic is locked

SQL Help

2/8/2011 11:45:55 AM
PHPRunner General questions
K
karmacomposer author

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

Sergey Kornilov admin 2/8/2011

Probably there is only one record on both tables that has matching EmployerID and holdby values.