merge two queries into one

[kkshansid]

State wise count of excellent (max pass count centres)
query1-> [code=mysql]Select code,sum( IF(PASS_FAIL='P ',1,0)) AS Cp from table group by code[/code]
I made table5 from above query then i executed query2 to get desired data
Query2->[code=mysql]SELECT Sheet1.state, code,Sheet1.add ress,stdcnt
FROM Table5 INNER JOIN Sheet1 ON Table5.code = Sheet1.centreco de
order by state,stdcnt desc;[/code]
kindly help me to merge these two queries into one

[code green]

it would be helpful if you could be bothered to:
1. Use code tags
2. Used accepted standards of syntax
3. If you don't follow standards at least be constent
Anyway

Select code,sum( IF(PASS_FAIL='P',1,0)) 
AS Cp from table group 
INNER JOIN 
(SELECT Sheet1.state, code,Sheet1.address,stdcnt
FROM Table5 Sheet1)
ON Table5.code = Sheet1.centrecode
order by state,stdcnt desc;

Something along those lines