Not sure how to approach this query

[sciencebear]

I have a table I want to select from twice. It's called updates and I first want to select all updates where the username is equal to a variable $username. Second, in the same table, I want to select again from the table each update whose id matches the id in a second table, comments, where friendname is equal to the same variable $username. I then want to order all of these by id. I tried a few variations on JOINs but couldn't get it to work quite the way I wanted. I was thinking maybe something with a UNION but I couldn't figure out a working syntax for that either. Any suggestions?

[cags]

I'm not sure if I'm fully understanding what your after, it sounds like you want something along the lines of...

 

SELECT u.*, c.* FROM updates u JOIN comments c ON u.username=c.friendname WHERE u.username=$username

 

[tomdchi]

Try this join

 

SELECT updates.*, othertable.id, othertable.comments, othertable.friendname 
FROM update, othertable 
WHERE updates.id = othertable.idfromupdates AND updates.username = othertable.username ORDER BY updates.id

[fenway]

That would be better if if actually used JOIN, not commas.