RE:

• Krishna Mohan Thamisetty

  SSC Rookie

  Points: 34

  More actions

  August 23, 2006 at 11:21 am

  #169994

  We can use Exists instead of Outer Join which is more speed than Outer Join

  When you are not expecting any column from second table then don't use Join use only Exists. Like following

  SELECT S.* FROM Students s

   WHERE NOT EXISTS

   (

    SELECT 1 FROM StudentExam se WHERE se.ExamName = 'SQL Server'

    AND S.StID = SE.StID

  &nbsp