It appears that the comparison in a join is not being
honored correctly. With the query and table data below I
get the row indicated instead of nothing as I would expect.
Is there something I am missing as far as configuration or
syntax?
SELECT ACTIVITY.ACTIVITY, AAAAA.*
FROM DBO.ACTIVITY ACTIVITY
INNER JOIN DBO.AAAAA AAAAA ON
ACTIVITY.ACTIVITYCODE=AAAAA.AAAAAA
table data:
AAAAAA
-------
A
b
c
C
ACTIVITY,ACTIVITYCODE
-----------
ASSMT A <- returns this row
Payment 1
Payment 1
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
