Last MyChenQL question for tonight
 

SELECT DISTINCT ensures that no two duplicate rows are returned. What would be the keyword for ensuring that no two values in one particular column are repeated across rows? For example:
[sql]SELECT threadid, forumid FROM thread[/sql]
How can I ensure that no duplicate forumids are returned.

Try:

'SELECT threadid, forumid, FROM thread GROUP BY forumid;'

:)

Great, thanks, that worked :D