>Hi,
> I tried to retreive some data from an Oracle database using remote views. There are 2 fields in a table of datatype DATETIME. Only one of the DATETIME column has values inside, the other one is empty. However, when I perform a 'select' statement to the view, the blank DATETIME field was filled with the data of the other DATETIME field.
>When I checked the original database, only one field has data in it.
>
>Any idea?
>
>Thanks
Can you show us the select statement?