Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Amin Sobati The Pitfall of "Not Equal To" Operator in Queries! RE: The Pitfall of "Not Equal To" Operator in Queries!
nileshsane
Default port
Points: 1465
More actions
August 23, 2006 at 4:51 am
#656315
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