TABLE A & C DATA LOCATED IN ORACLE TABLE B DATA LOCATED IN SAS WORK SPACE EXAMPLE 1 proc sql; select * from Table a inner join Table b on a.ID = b.ID; quit; The above query is translated as the following in Oracle Session; /*SELECT "COL1", "COL2" FROM Table a WHERE ( ("ID" IN ( 1191 , 1192 , 1193 , 1194 , 1195 , 1196 , 1197 , 1198 , 1199 , 1200 ) ) )*/ EXAMPLE 2 proc sql; select * from Table c inner join Table b on c.ID = b.ID; quit; The above query is translated as the following in Oracle Session; /*SELECT "COL1", "COL2" FROM Table c WHERE ((("ID"=:"ID") OR (("ID" IS NULL ) AND ( :"ID" IS NULL ))))*/ Example 2 has omitted the ID's and shows up differently to Example 1 'WHERE' clause despite the same query. It only happens when I used "Table C" but all the other table outputs as Example 1 'where' clause. Does anyone know why that is happening? What could be the issues? Thanks M
... View more