Inner Join not working
Posted: Tue Dec 11, 2012 10:36 pm
Hi All,
My Source is ODBC database and my reference and target table is DB2.
In source and reference table have a column like SITE_DESC datatype is a varchar.
I have verified the data seperately in each database. Identified some common records between tehm.
But When I was doing a inner join based on SITE_DESC between these two database, none of the records are not loaded to the target table.
But in the reference table if I keep some where condition clause,then some records are loading into the target table.
I really dont know the reason why inner join condintion is not working without where clause.
Any help is really appreciated.
My Source is ODBC database and my reference and target table is DB2.
In source and reference table have a column like SITE_DESC datatype is a varchar.
I have verified the data seperately in each database. Identified some common records between tehm.
But When I was doing a inner join based on SITE_DESC between these two database, none of the records are not loaded to the target table.
But in the reference table if I keep some where condition clause,then some records are loading into the target table.
I really dont know the reason why inner join condintion is not working without where clause.
Any help is really appreciated.