SQL Query

Select * from student where studid not in (select studid from studentdetails union select -1 as studid)