Querying multiple table using TCL called proc

Huh?  I have used Tcl ODBC and SQLite to do all sorts of inner and outer joins with no problem.

My guess is if using ODBC you are not setting up the columns correctly.  Look at the message, it says “Fetched Column Name is >ALIAS<"

I agree with Charlie.  We use joins all the time with no issue.

A basic question:  Do you have any ODBC queries working from inside Cloveleaf, or is this your first attempt?

Have you tried it without the join – just to see if that resolves the problem?

Find a person_id value and use it directly in a simplified query – something like:

SELECT alias from person_alias

        WHERE active_ind = ‘1’

          person_id = ‘yourTestPersonIdHere’

          and alias_pool_cd = ‘33451’

          and person_alias_type_cd = ‘4’

Then, if that works, add the joins one at a time to see where it breaks.

Have you run the query from a Cloverleaf Tcl shell?  Does it work there?

Oops… left out an “and”

SELECT alias from person_alias

       WHERE active_ind = ‘1’

         and person_id = ‘yourTestPersonIdHere’

         and alias_pool_cd = ‘33451’

         and person_alias_type_cd = ‘4’

[/b]

Correct.