Querey to add matched data and retain unmatched data in results

[Telarien]

Greetings!

Say I have a database with two tables:

Table one: Assets (has three fields) F1 "Serial Number" F2 "Machine Name" F3 "UserName"
Table two: Locations (has three fields F1 "UserName" F2 "BuildingNo" F3 "RoomNo"

Table one has 500 records, but Table two only has 50 records

Using "UserName" to match the tables, I want my Query results to look like:

F1 "Serial Number" F2 "Machine Name" F3 "Username" F4 "BuildingNo" F5 "RoomNo"
And contain **All 500 records from table one.



Those that match will have fields 4 and 5 populated, and those that dont match will have fields 4 and 5 blank.

How can I do that?

[June7]

Did you try query with JoinType of 'Show all records from Table One and only those from Table2 that are equal'?