sql structure question

[fogofogo]

I'm new to sql and have come up with a problem and can't seem to find the answer. Most would probably find it simple but I cant get my head around it! :p

I have the following table structure

User_Table
-----------
User_ID (Key)
FirstName
LastName


Contacts_Table
--------------
User_ID (F key)
Contact_User_ID


User_Table stores all users details and assigns them a User_ID. Users can add other users to their contacts, and this will be stored in Contacts_Table on a one-to-many basis.

*deep breath*... So User_ID in Contacts_Table, will store the User_ID from User_Table, and the Contact_User_ID in Contacts_Table will store the User_ID from User_Table. Does this seem ok? Sorry if I confused everyone!

So my question is, how do I select a user and show all his contacts (names etc)? I thought I could use innerjoin but I dont think it would work here.

Any ideas?

Thanks!

[fogofogo]

resolved

SELECT
C.[FirstName],
C.[LastName]
FROM
[Contacts_Table] AS C
INNER JOIN [Users_Table] AS U ON U.[User_ID] = C.[Contact_User_ID]
WHERE
C.[User_ID] = '0'