Different results View vs Query?

• shurag

  Old Hand

  Points: 359

  More actions

  November 19, 2003 at 10:56 am

  #162697

  Hi,

  I have a query retrieving results from two tables in different database using UNION but when I create a view on the same query the result set is different. The view is extracting much more rows then the query, I think it is retrieving duplicate records but Query used in the view is exactly same.

  How can I get the same results from the View as I get from the Query?

  Does anyone has input in this situation?

• SJTerrill

  SSCrazy

  Points: 2938

  More actions

  November 19, 2003 at 1:08 pm

  #482735

  Hmm. I've never observed that behavior. Could you past in some code we can look at?

  --SJTerrill