Duplicate values

[seanog2001]

is there a way to stop duplicate values appearing in a query result.

i querying a table but i dont want to see the same value twice ca i prevent this?

 

[RCurtin]

if you are only returning one field in your query you could use the DISTINCT keyword in sql

e.g. SELECT DISTINCT fieldname FROM tablename

Can you give more details on what you are trying to do?