[ic] complex sql select statements

John Allman interchange-users@icdevgroup.org
Tue Sep 10 13:08:01 2002


Mike Heins wrote:

>  
>
>>i tried table=cattable but that didn't help either:( i'm afraid i dont 
>>understand your last paragraph. are you saying it is an invalid query? 
>>    
>>
>
>I am saying that the query is failing, so it tries to run the query
>through SQL::Statement to determine the table name and see if *that*
>table can pass the query. With the complex query, SQL::Statement cannot
>determine which table it is.
>  
>
ok - with you so far...

>  
>
>>the thing that is getting me is that it works in the other catalog.
>>
>>    
>>
>
>Then your catalog configurations are different.
>
>If you are stuck on this, you may need a competent consultant to help
>you nail it.
>
>  
>
Can you suggest something in the configurations which might be causing 
this? or can you suggest a way to trace the exact source of the problem? 
The only real difference between the catalogs that i can see is that one 
uses two databases...

thanks

John Allman