Multiple table query displays only one record

E

Elaine_Moore

I have a table the has information about grant applications. I have another
table that has the names and addresses of the schools related to the
applications. When I do a querry it either shows only one record or all of
the information form one or the other depending on whetner I click 2 or 3 in
the properties window. How do I get it to show all of the records from all of
the columns that I have chosen from both tables?
 
P

PieterLinden via AccessMonster.com

Elaine_Moore said:
I have a table the has information about grant applications. I have another
table that has the names and addresses of the schools related to the
applications. When I do a querry it either shows only one record or all of
the information form one or the other depending on whetner I click 2 or 3 in
the properties window. How do I get it to show all of the records from all of
the columns that I have chosen from both tables?
Click to expand...

Full outer joins require basically unioning a left join and a right join.
e.g.

SELECT <fieldlist>
FROM a LEFT JOIN b
ON a.fieldx = b.fieldy
UNION ALL
SELECT <fieldlist>
FROM a RIGHT JOIN b
ON a.fieldx = b.fieldy
 
E

Elaine_Moore via AccessMonster.com

Hi Pieter,

Here is the SQL for my query. I am not sure what you are saying it should
look like. I am a beninner here, so please be patient with my ignorance.

SELECT tblM2010Excel.FileNumber, tblM2010Excel.[Teacher Name],
tblSchoolsExcel.ID, tblSchoolsExcel.SchoolName, tblSchoolsExcel.StreetAddress,
tblSchoolsExcel.City, tblSchoolsExcel.Province, tblSchoolsExcel.PostalCode
FROM tblSchoolsExcel INNER JOIN tblM2010Excel ON tblSchoolsExcel.[SchoolName]
= tblM2010Excel.[School Name];
 
Top