you should open a tar and send your code. you may have a syntax issue. we are using join in a few places with 9205 and do not have this problem. didnt have the problem in 9203 either. -------------- Original message -------------- > As mentioned earlier I applied the 9205 patch set to the w2k > yesterday. today we are getting issues. it seems that we cannont use > an explicit join in our queries where they were working in the 9201 > base install. -- //www.freelists.org/webpage/oracle-l