How? Join twice against same table?

How do I get a record back that shows 2 independent fields from a second table ?
Table AAA: CREATE TABLE AAA (

              field_A1        VARCHAR2(10),
              field_A2_RefB1  NUMBER,
              field_A3_RefB1  NUMBER
            );


Table BBB:  CREATE TABLE BBB (
              field_B1        NUMBER       UNIQUE NOT NULL,
              field_B2        VARCHAR2(10)
            );

Fields field_A2_RefB1 and field_A3_RefB1 reference field_B1

Data of Table AAA: "A1", 1, 2

Data of Table BBB: 1, "B1"

                    2, "B2"
Relation: Table AAA:  "A1", 1, 2
                            |  |
                            |  |
          Table BBB:        |  +-> 1, "B1"


                            +----> 2, "B2"

Desired output: A1, B1, B2

Select statement like:

     SELECT field_A1,
            DECODE(field_A2_RefB1, SELECT-stmt ??),
            DECODE(field_A3_RefB1, SELECT-stmt ??)
     FROM   AAA, BBB
     WHERE  ...

NO hard-coding within DECODE wanted !

   (like DECODE(field_A2_RefB1, 1, "B1", 2, "B2") ) Received on Tue Dec 06 1994 - 15:24:34 CET