SELECT [Mother's Information].[Student ID#]
,[Students details].[Student ID#] AS [Student ID#_Students details]
,[Students details].[Last Name]
,[Students details].[First Name]
,[Students details].[Middle Name]
,[Students details].Gender
,[Students details].[Date Of Birth]
,[Students details].Age
,[Students details].Nationality
,[Students details].[Entry Grade]
,[Students details].[Date Enrolled]
,[Students details].Street
,[Students details].City
,[Students details].Parish
,[Students details].[Student Picture]
,[Mother's Information].[Last Name] AS [Last Name_Mother's Information]
,[Mother's Information].[First Name] AS [First Name_Mother's Information]
,[Mother's Information].Nationality AS [Nationality_Mother's Information]
,[Mother's Information].Street AS [Street_Mother's Information]
,[Mother's Information].City AS [City_Mother's Information]
,[Mother's Information].Parish AS [Parish_Mother's Information]
,[Mother's Information].Occupation
,[Mother's Information].Employer
,[Mother's Information].[Home Phone]
,[Mother's Information].[Mobile Phone]
,[Mother's Information].[Work Phone]
,[Mother's Information].[email address]
,[Mother's Information].ID
,[Mother's Information].[ID#]
,[Father's Information].[Student ID#] AS [Student ID#_Father's Information]
,[Father's Information].[Last Name] AS [Last Name_Father's Information]
,[Father's Information].[First Name] AS [First Name_Father's Information]
,[Father's Information].Nationality AS [Nationality_Father's Information]
,[Father's Information].Street AS [Street_Father's Information]
,[Father's Information].City AS [City_Father's Information]
,[Father's Information].Parish AS [Parish_Father's Information]
,[Father's Information].Occupation AS [Occupation_Father's Information]
,[Father's Information].Employer AS [Employer_Father's Information]
,[Father's Information].[Home Phone] AS [Home Phone_Father's Information]
,[Father's Information].[Mobile Phone] AS [Mobile Phone_Father's Information]
,[Father's Information].[Work Phone] AS [Work Phone_Father's Information]
,[Father's Information].[email address] AS [email address_Father's Information]
,[Father's Information].ID AS [ID_Father's Information]
,[Father's Information].[ID#] AS [ID#_Father's Information]
,[Contact person information].[Student ID#] AS [Student ID#_Contact person information]
,[Contact person information].[Last Name] AS [Last Name_Contact person information]
,[Contact person information].[First Name] AS [First Name_Contact person information]
,[Contact person information].[Relationship with child]
,[Contact person information].[Home Phone] AS [Home Phone_Contact person information]
,[Contact person information].[Mobile Phone] AS [Mobile Phone_Contact person information]
,[Contact person information].[Work Phone] AS [Work Phone_Contact person information]
,[previous school].[Student ID#] AS [Student ID#_previous school]
,[previous school].[Name of school]
,[previous school].Street AS [Street_previous school]
,[previous school].City AS [City_previous school]
,[previous school].[Parish/State]
,[previous school].[Contact person]
,[previous school].Telephone
,[previous school].[Last grade attended]
,[previous school].Assistance
,[previous school].Repeat
,[previous school].Suspended
,[previous school].Expelled
,[health information].[Student ID#] AS [Student ID#_health information]
,[health information].Allergies
,[health information].[Please state allergies (if yes)]
,[health information].Treatment
,[health information].[current medical treatment]
,[health information].[Please state (if yes)]
,[health information].[Med Treatment]
,[health information].[Epilepsy (fits)]
,[health information].Asthma
,[health information].[other medical problems]
,[health information].[Please state others (if yes)]
,[health information].[Child's Doctor]
,[health information].[Doctor's Address]
,[health information].[Doctor's telephone]
,[health information].[Fully Immunized]
,[health information].[Please state (if no)]
,[other information].[Student ID#] AS [Student ID#_other information]
,[other information].[Religious affiliation]
,[other information].[Hopes & Ambitions]
,[health information].[Student ID#] AS [Student ID#_health information1]
,[Contact person information].[Student ID#] AS [Student ID#_Contact person information1]
,[Students details].[Student ID#] AS [Student ID#_Students details1]
,[Father's Information].ID AS [ID_Father's Information1]
,[Contact person information].[Last Name2]
,[Contact person information].[First Name2]
,[Contact person information].[Relationship with child2]
,[Contact person information].[Home Phone2]
,[Contact person information].[Mobile Phone2]
,[Contact person information].[Work Phone2]
,[Contact person information].[Last Name3]
,[Contact person information].[First Name3]
,[Contact person information].[Relationship with child3]
,[Contact person information].[Home Phone3]
,[Contact person information].[Mobile Phone3]
,[Contact person information].[Work Phone3]
,[report cards].[Student ID#] AS [Student ID#_report cards]
,[report cards].[Report cards]
,[Students details].[Birth certificate ref#]
FROM (
(
(
(
(
(
[Students details] LEFT JOIN [Mother's Information] ON [Students details].[Student ID#] = [Mother's Information].[Student ID#]
) INNER JOIN [Father's Information] ON [Students details].[Student ID#] = [Father's Information].[Student ID#]
) LEFT JOIN [Contact person information] ON [Students details].[Student ID#] = [Contact person information].[Student ID#]
) LEFT JOIN [previous school] ON [Students details].[Student ID#] = [previous school].[Student ID#]
) LEFT JOIN [health information] ON [Students details].[Student ID#] = [health information].[Student ID#]
) LEFT JOIN [other information] ON [Students details].[Student ID#] = [other information].[Student ID#]
)
LEFT JOIN [report cards] ON [Students details].[Student ID#] = [report cards].[Student ID#];
