[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

faster select



Which of these selects would be more efficient/faster in comparing
data from two different databases?

  from tt_shop
 where department = $dept
   and shop in (select master-shop from ldsloc.dbo.tt_shop)
!  and exists  (select master-shop from ldsloc.dbo.tt_shop
!                where master-shop = shop)
 order by department, division, branch, shop

Angel