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