Not listing a record because it is in another Columns

[czarjosh]

Here is my dilemma. I have a database that we use to register people for a conference. In the table Registration there is a Long Integer field for Roommate, which stores the Value of the RecNumber value of a another record. This was so I could assign roommates based on people who were already registered.

Now I am trying to print off a roommate list, and I am trying to figure out how to make it not print doubles. Here is what I get

Name Roommate
----------- ------------
Joe Smith Sally Mae
Sally Mae Joe Smith
Eric Smile etc


I want it to say


Name Roommate
----------- ------------
Joe Smith Sally Mae
Eric Smile etc

Can this be done?

 

[Crowley16]

eh, have you tried using the DISTINCT keyword?

SELECT DISTINCT blah, blah FROM blah...

can you give us an example of your table and the query you are using for further clarification?