• Nice article.

    Another way of writing the same, for those who prefer the old convention (I dont recommend it).

     

    SELECT

    s.*, se.* FROM Students s ,

    (SELECT * FROM StudentExam WHERE ExamName='SQL Server') se

    where

    s.StID !=se.StID


    What I hear I forget, what I see I remember, what I do I understand