Problem with joins
I am having a problem while executing the following query in JDBC . The result should return 13 rows with join operators in place.. But I am getting 10 records,as if I havent placed joins....
How to convert this query so that it can be executed under JDBC................
SELECT PROFILE_TOPICS.TOPIC_ID, PROFILE_TOPICS.TOPIC_TYPE TOPIC_TYPE, PROFILE_TOPICS.TOPIC_NAME AS QUESTIONS, PROFILE_TOPICS.TOPIC_TYPE_VALUE AS OPTIONS, client_PROFILE.TOPIC_VALUE AS ANSWERS, client_PROFILE.DISPLAY_OTHERS AS MAKE_VISIBLE, NVL(client_PROFILE.DATE_CREATED,'') AS DATE_CREATED
FROM PROFILE_TOPICS,client_PROFILE
WHERE client_PROFILE.client_ID(+)= 32 AND PROFILE_TOPICS.SOURCE_SKILLBAY=0 AND PROFILE_TOPICS.TOPIC_SOURCE_CLI_MEM IN (0,2)
AND PROFILE_TOPICS.TOPIC_ID=client_PROFILE.TOPIC_ID(+)
ORDER BY PROFILE_TOPICS.SEQUENCE_NO
