Select from 3 tables to display unique data for each particular Case No

Hi Friends,
I have 3 tables from which i have to display a set of records, for one particular attribute .say : Case no.
But when i am writing the select statement, all the rows of that particular Case no are retrieved. and i am unable to repair the query, acc to my needs.
---------------------------------------------------------
my tables are
1. CASEFILING table - from where COMPLAINANT , RESPONDENT,COMPL_ADV,RESP_ADV to retrieve
2. COURTROOM table - from where CASESTAGEID to be retrieved
3. CASESTAGE table- from where CASESTAGE to be retrieved for a specific CASESTAGEID (from COURTROOM table)

CASEFILING , COURTROOM table have pkey as CASE_ID_IN
---------------------------------------------------------

Another thing, in COURTROOM table, there can be many records wrt only one CASE_ID_IN .But they have different HEARINGNO, which could be 1 ,2 .....and so on.

So while retrieving the data, i was using MAX(HEARINGNO).
But still i can retirive only one row, for only one caseno. and no result, for other case nos.

Pls Help
Thanks in advance
royz4u