tcl proc doing an oracle ‘join’

Cloverleaf 5.7 patch 2 – AIX

I’m trying to run a tclproc that is querying a database using a join:

Select e2.alias from encntr_alias e1, encntr_alias e2  

               Plan e1

               Where e1.alias = “21559168”

               And e1.encntr_alias_type_cd = 389  

               And e1.active_ind = 1.00  

               Join e2  

               Where e2.encntr_id = e1.encntr_id

               And e2. encntr_alias_type_cd = 15695  

               And e2.active_ind = 1.00  

I keep getting the “SQL command not properly ended” error.  

First, is it possible to do a join using tcl, and if so, would someone have an example to share?

Thanks.

Mike C.