Simple Query Need Help

~Bean~ · June 27th, 2005, 10:49 AM

Please help with my simple query...I have 2 tables in a FORUM Database for Users and Threads. I am trying to return all the usernames that have posted in a Thread.

tblUsers
UserID
UserName
etc...

tblThreads
ThreadID
TopicSubject
UserID
UserPost
etc...

???

-------------------------
Beware of programmers with screwdrivers...

rgerald · June 27th, 2005, 11:13 AM

Try this:

Code:

SELECT DISTINCT ThreadID, UserName 
FROM tblUsers u
INNER JOIN tblThreads t
   ON u.UserID = t.UserID

Rand

~Bean~ · June 27th, 2005, 11:22 AM

thx Rand!

-------------------------
Beware of programmers with screwdrivers...