datalist bind problem...

[Techno]

Hi there. I hope you are in the best of health :)

I need some help....

I have a asp.net page, and it binds to a stored proc (the data) in SQL Server.

Great, i get the results i require.

So i get the fields:

ThreadName (made into a hyperlink button using the navigateurl databind control)
User

and other data

stored proc is simply:

SELECT * FROM Threads

ok...

Threads table has the fields ThreadID, ThreadName, UserID and some other fields

What i want is, the User dataitem in the grid/list to show the username from "Accounts" table for each record it retrieves from the stored proc

its hard explaining but i hope you understand. if not, please let me know. I really would like some replies :)

thank-you :)

[Techno]

sorted, SQL Server statement had to be modified to use JOIN statement ;) works like a charm - for now :)