Hi
I have 2 tables bugs and users. Their structure with sample data is as follow:
bugs
bug_id assigned_to qa_contact
1 1 2
2 2 2
users
user_id name
1 foo
2 bar
I want a result table like this
bug_id assigned_name qa_name
1 foo bar
2 bar bar
that is i want the name instead of ids. can any one give me the query to retrieve this info
thanks
