Left Outer Join

[Guest]

Hello:
How can I make this query a Left Outer Join? I want all institution names
from the institution table and only the institutions from the History table
that have a previous name. Thanks J.
Select DistinctRow [Institution name], [Institution id], [Corporation id]
from [Institution table]
UNION Select [previous name], [Institution id], [Corporation id] from
[History table]
ORDER BY [Institution name];

 

[Ken Snell \(MVP\)]

Try this:

SELECT DistinctRow T.[Institution name], T.[Institution id],
T.[Corporation id], H.[previous name]
FROM [Institution table] AS T LEFT JOIN
[History table] AS H
ON T.[Institution id] = H.[Institution id]
ORDER BY T.[Institution name];

 

[Guest]

That worked perfectly. Thanks for your help, Ken
Jackie.

Try this:

SELECT DistinctRow T.[Institution name], T.[Institution id],
T.[Corporation id], H.[previous name]
FROM [Institution table] AS T LEFT JOIN
[History table] AS H
ON T.[Institution id] = H.[Institution id]
ORDER BY T.[Institution name];

--

Ken Snell
<MS ACCESS MVP>

Hello:
How can I make this query a Left Outer Join? I want all institution names
from the institution table and only the institutions from the History
table
that have a previous name. Thanks J.
Select DistinctRow [Institution name], [Institution id], [Corporation id]
from [Institution table]
UNION Select [previous name], [Institution id], [Corporation id] from
[History table]
ORDER BY [Institution name];

 

[Ken Snell \(MVP\)]

You're welcome.