Have you tried to use the JOIN statement instead of WHERE clause?

And then, group the similar items together by using a Group By function. Maybe it will work then.:hehe:

i'm fariz.

Thanks for the information. But there are still a troubleshoot as i get in to the sql plus program. ive read the tnsname.ora file as you all suggested it,...