query that filters out those schoolcode

[kkshansid]

i hav 2 tables named student and school
student fields
stdid,stdname,s choolcode,resul t
school fields
code,name,state
i have to make join of both tables on schoolcode=code but some school code are not present in school field
plz help to make a query that filters out those schoolcode that are present in student table but not present in school table so that i can fill school table with those code

[gpl]

Read Books Online and see what it says about LEFT OUTER JOIN

This will help you solve your problem of missing details