NikhilS <nikkhils@gmail.com> writes:
> Yes this is fine, but in "select columnname from tablename" using column
> references of the other involved table is what I am objecting to.
You can object till you're blue in the face, but this behavior is not
changing because it's *required by spec*. Outer references are a
standard and indeed essential part of SQL.
regards, tom lane