By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

query that filters out those schoolcode

100+
P: 232
i hav 2 tables named student and school
student fields
stdid,stdname,schoolcode,result
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
Feb 11 '09 #1
Share this Question
Share on Google+
1 Reply


100+
P: 152
gpl
Read Books Online and see what it says about LEFT OUTER JOIN

This will help you solve your problem of missing details
Feb 12 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.