SELECT p.PROD_NAME, pv.PROD_VERS_NAME, cl.COMPA_LVL_NAME
FROM TBL_PROD AS p, TBL_PROD_VERS AS pv, TBL_PROD_VERS_ALLOC AS pva, TBL_COMPA_LVL AS cl, TBL_COMPA AS c
WHERE p.PROD_ID=pva.PROD_ID And pv.PROD_VERS_ID=pva.PROD_VERS_ID And cl.COMPA_LVL_ID=c.COMPA_LVL_ID And pva.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_B
And p.PROD_ID=66;

SELECT p.PROD_NAME_A, p.PROD_NAME_B, [....]

SELECT pa.PROD_NAME, pb.PROD_NAME, pv1.PROD_VERS_NAME, pv2.PROD_VERS_NAME,cl.COMPA_LVL_NAME

    FROM TBL_PROD AS pa, TBL_PROD AS pb,TBL_PROD_VERS AS pv1, TBL_PROD_VERS AS pv2,
TBL_PROD_VERS_ALLOC AS pva, TBL_PROD_VERS_ALLOC AS pvb,
TBL_COMPA_LVL AS cl, TBL_COMPA AS c

    WHERE
    pa.PROD_ID=pva.PROD_ID And
    pv1.PROD_VERS_ID=pva.PROD_VERS_ID And
    pva.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_A And

    pb.PROD_ID=pvb.PROD_ID And
    pv2.PROD_VERS_ID=pvb.PROD_VERS_ID And
    pvb.PROD_VERS_ALLOC_ID=c.PROD_VERS_ALLOC_ID_B And

    cl.COMPA_LVL_ID=c.COMPA_LVL_ID And
    p.PROD_ID=66;