mysql - multiple where clause in sql -

i don't know if possible give try.

i have 3 tables:

first table: (sender_id , receiver_id foreign key referencing loginportal table)

messages sender_id | receiver_id | message     3     |      1      |   ... 

second table: (req_id foreign key referencing request table)

loginportal loginportal_id | username | req_id      1         |   admin  |    1      3         |    user  |    2 

third table:

request req_id | firstname | surname    1   |    john   |   doe    2   |    jane   |   me 

problem:

whenever used query:

"select id, message_sender_id,          message_title, message_body, sent_date, message_status,         username, firstname, surname         messages m         inner join loginportal l         inner join request r         on m.message_receiver_id= l.loginportal_id         , l.req_id=r.req_id         m.message_receiver_id=(         select loginportal_id loginportal          username='".$_session['user']."')"; 

what got receiver username , receiver firstname , surname. want have receiver username sender's firstname , surname. possible?

i think need add message_id field, combine 2 subqueries finding sender , reciever info on new message_id. along these lines...haven't tested it

select query1.username, query2.firstname, query2.surname  (select username, message_id loginportal, messages loginportal_id = receiver_id) query1, (select firstname, surname, message_id request, loginportal, messages request.req_id = loginportal_req.id , loginportal.loginportal_id = messages.sender_id) query2  query1.message_id = query2.message_id;