Sybrand Bakker <sybrandb@hccnet.nl> wrote in message news:<0psfg05ls7q76ho09515mhu6i9fv1g38m0@4ax.com>. ..
> Show what you've got so far and where you are going wrong.

Using the following structure:
TblPerson { PersonId(PK), PersonName, PersonSurname, PersonTel }
TblEducation { QualificationId, PersonId(FK), QualificationName,
DateObtained }

This query:
SELECT PER.PersonId, EDU.PersonId, PER.PersonName, PER.PersonTel,
EDU.QualificationId, EDU.QualificationName, EDU.DateObtained
FROM TblPerson PER, TblEducation EDU
WHERE ((PER.PersonId = EDU.PersonId(+))

Gives me this result:
19612121,19612121,Peter Smith,234-444,Degree888,BComm,1989/05/24
19612121,19612121,Peter Smith,234-444,Diploma555,Marketing,1995/06/23
19881005,19881005,Mary Jane,587-3548,Diploma246,Accounting,1998/10/10
19500101,19500101,Jon Brown,222-3333,Degree195,Phd,1990/01/01

Peter Smith has 2 qualifications while the others have 1.
I'm stuck at the part where I join the two Peter Smith records so that
I get:

19612121,19600505,Peter
Smith,234-444,Degree888,BComm,1989/05/24,Diploma555,Marketing,1995/06/23

19881005,19881005,Mary Jane,587-3548,Diploma246,Accounting,1998/10/10

19500101,19500101,Jon Brown,222-3333,Degree195,Phd,1990/01/01

(example may wrap)