how to solve Mysql sub query

Question

Here is a a problem

select stockrequest.clientnum, requestlist.productnum,requestlist.qtyrequest
from stockrequest, requestlist 
where stockrequest.requestnum = requestlist.requestnum

this query will result

client num   productnum    qty
1            123            4
2            345            5
3            456            7


select client.clientname, stockrequest.clientnum
from client , stockrequest
where stockrequest.clientnum = client.clientnum

clientname   clientnum
yd              1
myer            2
nike            3

i need a subquery that will replace clientnum to client name in the first query

Answer 1

may you just select all :) (untested)

select s.clientnum, r.productnum, r.qtyrequest, c.clientname
from stockrequest s, requestlist r, client c
where s.requestnum = r.requestnum

Answer 2

Do a 3-way join:

SELECT c.clientname, rl.productnum, rl.qty
FROM stockrequest AS sr
JOIN client AS c ON c.clientnum = sr.clientnum
JOIN requestlist AS rl ON rl.requestnum = sr.requestnum