Correct SQL statement?

[oyad]

plz,i cant figure out the right SQL to retrieve what i want from my SQL server 2005 database.
I have two tables, Table 1 is named tUsers & its columns hav the from (UserId,SName,FName) while Table 2 is named tData with columns (Date,Msg,Pass, UserId1,UserId2). Both UserId1 and UserId2 of tData table depends on UserId of tUsers table. I want to retrieve each row from tData of the form : Date, Msg, Pass, UserId1,SName of UserId1, FName of UserId1, UserId2,SName of UserId2, FName of UserId2)

Am getting some unnecessary results from my joins, any person to help the right SQL
10q

[si_the_geek]

You just need to use two "instances" of the tUsers table, eg:

SELECT [Date], Msg, Pass, UserId1, U1.SName, U1.FName, UserId2, U2.SName, U2.FName
FROM tData
LEFT JOIN tUsers U1 ON (tData.UserID1 = U1.UserID)
LEFT JOIN tUsers U2 ON (tData.UserID2 = U2.UserID)