SELECT distinct c.CandidateID, c.FirstName, c.LastName, c.Email, c.Nationality, c.English, c.Spanish, c. French, c. Portuguese, c. OtherLanguage, c. OtherLanguageLevel, c. DOB, a.PostingID, a.CategoryType, e.DegreeID, d.Degree, x.exp

FROM Candidates c

INNER JOIN Pandc a ON...

Thank you Loner....

I am trying to learn SQL by following some tutorials and I came across this problem.

Thanks again for all your help.

Affu...

Thanks Sushila.

I will give that a try and get back to you.

Candidates Table: c. CandidateID, C. FirstName, c. LastName, c. Email, c. Nationality, c. English, c. Spanish, c. French, c. Portugese, c. OtherLanguage, c. OtherLanguageLevel, c. DOB

Education Table: e. IDEduc, e....