|
Hi all,
I'm fairly new to Access and SQL.
My sense is that my question is fairly basic, but I still need help
with it.
I have a table with players who are listed either in the fields
'player1' or 'player2', depending on what position they played in a
game.
I used an outer join to join the table to itself and combine the two
fields into one ('players_all').
In about half the game reports, field2 is empty (there was only one
player). When I join the table, I get a long list of blank fields in
'players_all' where there was no second player listed.
How do I write a query to list only those records where players_all
contains a name?
Thanks!
| 
