RE: SQL Select Statement in a Stored Procedure Question - GotFuther-But....

Ah, that explains why your sql statement doesn't blow up on the where
clause.

So this intermediary program leaves you in some kind of parallel CW
universe where all the field definitions are different ?  Is there no
item master file available to you there ? 

In the regular CW world, I would have done your query like this:

SELECT A.ASCOMP AS COMPANY,
TRIM ( A.ASBECD ) AS ITEM,
B.AREOTX AS ITEMDESCRIP
FROM CWMPDTA.INIOFR A INNER JOIN CWMPDTA.INITEM B
ON A.ASCOMP = B.ARCOMP and A.ASBECD =  B.ARBECD
WHERE A.ASCOMP = 1


|-----Original Message-----
|From: midrange-l-bounces+gfleming=evergladesdirect.com@xxxxxxxxxxxx
|[mailto:midrange-l-bounces+gfleming=evergladesdirect.com@xxxxxxxxxxxx]
On
|Behalf Of DebbieKelemen
|Sent: Thursday, March 23, 2006 3:16 PM
|To: 'Midrange Systems Technical Discussion'
|Subject: RE: SQL Select Statement in a Stored Procedure Question -
|GotFuther-But....
|
|Greg,
|
|We are using another program in between.
|
|Deb
|
|
|