Oracle Query table joins

I have a table TableA with 6 columns(col1,col2,col3,col4,col5,col6) and there is an other table TableB with 5 columns (colA, ColB(typeID), ColC, ColD, ColE). I need to fetch the col2 ...Col6 from tableA by joining with TableB. I would have to

join col2 from TableA with colB from TableB and again

join col3 from TableA with colB from TableB

join col4 from TableA with colB from TableB

join col5 from TableA with colB from TableB

Each of the column from TableA needs to be joined with same column (colB) in TableB.Here the typeid value will be different for each of the col types in TableAe The colB is a type id and hence col2, col3,col4, col5 are different types, hence they are kind being joined with colb. I need a query which will fetch all the values of col2, col3,col4, col5 and the colc value based on each type in the same query. I tried writing the query. But could not fetch all the values in a single query.I need to fetch the values for all the field in TableA using a single Query.

select ci.colc as naid from TableA pi join TableB ci on pi.col2 = ci.colb and ci.status_cd = 'AC'

To fetch the associated value for col3, i need to write the below query
select ci.colc as tabid   from TableA pi join TableB ci on pi.col3 = ci.colb and ci.status_cd = 'AC'
similarly for col4 the below query
select ci.colc as subid   from TableA pi join TableB ci on pi.col4 = ci.colb and ci.status_cd = 'AC'
Is there a way I can use a single query to fetch all the 3 col values. I know we can use union function and join the above three queries. But I wanted to know if there is a single query that I can use i.e
select ci.colc as naid, select ci.colc as tabid, select ci.colc as subid from TableA pi join TableB ci

In the above case, joining the fields seems to be an issue.

Any help on this is much appreciated.

You accidentally posted this thread twice. To avoid confusion, I locked the other copy so that people can only reply to this one.

I also moved it from Object Relational Mapping to JDBC and Relational Databases because the question seems to be entirely about SQL and not an ORM such as JPA.

As for the actual question, I don't really understand it, but it seems that you are trying to cram 3 different types of queries into a single SQL statement. SQL likes to present a tabular view for query results, and I don't think that your different query result sets would neatly fit into a set of identically-formed rows.

So in short, I think you are trying to do too much there and you should keep to the simpler approach with multiple queries.