I've a strange problem. Say I've tables A and B. 3 columns of A are foreign keys of table B. When I query table B with each of the values in the 3 columns independently it gives values. But when I link these three columns to the primary key of table B it's not returning me any results. How would I get data from B in this situation?

SELECT CUBE_LATTICE_.NAME, SURVEY_3D_.NAME, POSITION_.ORIGINAL_X_LONGITUDE, POSITION_.ORIGINAL_Y_LATITUDE, CUBE_LATTICE_.I_ANNOTATION_INCREMENT, CUBE_LATTICE_.J_ANNOTATION_INCREMENT                            FROM (PRJ1_SEIS.CUBE_LATTICE_ CUBE_LATTICE_                   INNER JOIN PRJ1_SEIS.POSITION_ POSITION_ ON CUBE_LATTICE_.POINT_0_0_POSITION_ID=POSITION_.ID AND CUBE_LATTICE_.POINT_0_J_POSITION_ID=POSITION_.ID AND CUBE_LATTICE_.POINT_I_0_POSITION_ID=POSITION_.ID)            INNER JOIN PRJ1_SEIS.SURVEY_3D_ SURVEY_3D_ ON CUBE_LATTICE_.SURVEY_3D_ID=SURVEY_3D_.ID                     WHERE CUBE_LATTICE_.NAME= {?surveyName}