New answers tagged


Such query will return the wrong result on a versioned table, unless all versions are posted and the DB compress to 1 state only. Instead of using the table directly, you need to use its corresponding version view. This view will take care of merging together the base table, the A (add) table and the D (deleted) table.

Top 50 recent answers are included