tcl proc doing an oracle ‘join’

[Mike Campbell]

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.

Topic

[Charlie Bursell]

You must specify the join type.  You probably want an inner join.

Take a look here

http://www.techonthenet.com/sql/joins.php

[Author]

Replies