how to retrieve values from more than two tables

[Mohd Nayeemuddin]

hai,
how to retrieve values into the ResultSet object from more than two tables by establishing a relation. Please solve my query with an example.


Thank Q.

Regards...
Nayeem

[Paul Sturrock]

Return a result set that is created from some sort of join.

For example, assuming:

create table tableA {
    id integer primary key,
    name varchar(30)
}
 
create table tableB {
    id integer primary key,
    someValue integer,
    tableA_id integer constraint fk_tableA 
                    references tableA(id)
}

You can write a query like this:

select * from tableA inner join tableB on tableB.tableA_id = tableD.id

which will return all records in tableA that also have a related tableB record.