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!

SELECT * FROM tblTable WHERE tblTable.players_all Is Not Null;