how get combine report with using tree query

[mfa786]

Sir I have tree spared query how i report how I link all query with each other the STUSECMTAMT .stdcode this is same column in each query


SELECT STUSECMTAMT .stdcode,RATES.description,RATES.amount,STUINV.amt-RATES.amount AS addotherfee,STUINV.amt,STUINV.discperc,(STUINV.amt/100)*STUINV.discperc AS disamo, STUINV.debit
FROM STUSECMTAMT,STUINV,RATES,STUJOURNAL WHERE STUSECMTAMT.vhno=STUJOURNAL.ref_no AND STUSECMTAMT.VHNO=STUINV.vhno AND STUINV.ratescode=RATES.ratescode AND STUSECMTAMT.SCHEME_MST_ID=RATES.SCHEME_MST_ID AND STUSECMTAMT.vhno='SIN02080018'

=====================
SELECT STUSECMTAMT .stdcode ,COURSES.name,COURSES.id,COURSES.crhrs,STUDEG.DEGREE_code,SCHEME_DEG_DET.amount FROM STUSECMTAMT,STUDEG,SCHEME_DEG_DET,SECCORS,COURSES,STUSEC
WHERE STUSECMTAMT.STUDEGid=STUDEG.STUDEGid AND STUSECMTAMT.scheme_mst_id=SCHEME_DEG_DET.scheme_mst_id AND
STUDEG.degree_code= SCHEME_DEG_DET.degree_code
AND
STUSEC.seccorscode=SECCORS.seccorscode AND SECCORS.coursescode=COURSES.coursescode AND STUSEC.vhno=STUSECMTAMT.VHNO
AND STUSECMTAMT.vhno='SIN05080109'

=======================
SELECT STUDENTS.STDCODE,STUDENTS.NAME,STUDENTS.FNAME,STUDENTS.ADDRESS1,STUDENTS.ADDRESS2,
STUDENTS.PHONE,STUDENTS.DEPART,STUDENTS.NIDCNO,STUDENTS.EMAIL
,SUM(STUSECMTAMT.TOTALCR) AS tchr,SUM(STUSECMTAMT.TOTDEBIT) AS tdebit,SUM(STUSECMTAMT.OTHERDR) AS totherdebit,SUM(STUSECMTAMT.GROSSDEBIT) AS grossdebit,SUM(STUSECMTAMT.DISCOUNT) AS discount,SUM(STUSECMTAMT.REFUND) AS refund,SUM(STUSECMTAMT.ADJAMOUNT) AS adj,SUM(STUJOURNAL.CRE_BAL) AS to_credeit,SUM(STUSECMTAMT.TOTDEBIT) -SUM(STUJOURNAL.CRE_BAL) AS balance
FROM STUDENTS,STUSECMTAMT,STUJOURNAL
WHERE STUDENTS.STDCODE=STUSECMTAMT.STDCODE AND STUSECMTAMT.vhno=STUJOURNAL.ref_no AND STUSECMTAMT.STDCODE ='021-99-10610'
GROUP BY STUDENTS.STDCODE,STUDENTS.NAME,STUDENTS.FNAME,STUDENTS.ADDRESS1,STUDENTS.ADDRESS2,
STUDENTS.PHONE,STUDENTS.DEPART,STUDENTS.NIDCNO,STUDENTS.EMAIL

Please give me idea how I get combine report using tree query

What I use data link or what

thanks

aamir