Need help with a MySQL query

[Redline]

Here's the description of the query I need to make:

SELECT comments.*, user.user_dname (where user.user_id = comments.user_id), user.user_dname AS replyto_user_dname (where user.user_id = comments.replyto_user_id) FROM comments WHERE blog_id = bid


What I'm doing is selecting all comments made on a specific blog entry, and in each row I need to include the posters display name, and the display name of the person the poster is replying to. I was thinking I needed to perform some sort of JOIN, but then I'm not sure if I can perform conditional statements for specific fields? My brain hurts.

[Redline]

Holy hell. I think I might have solved my problem. I figured it was a longshot, but I tried the following sql query:

$query = "	SELECT 
		comments.*, 
		users.user_dname, 
		(SELECT user_dname FROM users WHERE user_id=comments.replyto_user_id) AS replyto_user_dname 
		FROM comments, users 
		WHERE comments.blog_id='$bid' AND comments.user_id=users.user_id";

And it seems to be doing what I wanted it to do; return display names for two different user id's defined in the comments table. Any feedback as to the efficiency of this query? Is there a better, more efficient way to do it with JOINs or UNIONS or something?

[DJMaze]

SELECT c.*, u.user_dname, r.user_dname AS replyto_user_dname
FROM comments AS c, user AS u, user AS r
WHERE c.blog_id = bid, c.user_id = u.user_id, c.replyto_user_id = r.user_id

The query itself is pretty big since it needs to search in the user table twice.