H
Håvard Danielsen
Guest
Thanks. But I have to use self join because the required results are not displayed without self join. This query will return duplicate rows if there is more than one Table_A of the requested date. (unless there is a unique index that prevents it). This is typically not desirable. It is fully possible to define this query with a buffer in an SDO and browse the records, but this SDO should not be used to update data. The SDO do not refresh/sync other occurrences of the same record after an update . Support will be able to show you how to define this join in the SDO. I suspect it is not possible to write a query that eliminates the duplicate entries (I could be wrong). In that case you might fill a temp-table with a single record even if there are many Table_A for the criteria and use this as the top record in the query instead of the Table_A.
Continue reading...
Continue reading...