Elaine_Moore wrote:
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?
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1