Don Hayes wrote:
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
What the heck do you think is wrong? That is the correct result!
Jan _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
