SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help! :)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sikharma13
Starting Member

Philippines
40 Posts

Posted - 11/16/2013 :  19:12:32  Show Profile  Reply with Quote
i have table payroll and has column number of eligible for education

entry_id===no_eli_educ
00000001========2=====
00000002========3=====
00000003========0=====


and i havecolumn name_of_schools in table schools

entry_id===name_of_schools
00000001===adamson high
00000002===lasalle high
00000002===no facility
00000002===guanlun high
00000003===no facility

i want to add a column number of no school in my payroll table

wherein this is my expected output

number_of_no_school
00000001===0
00000002===1
00000003===0

since entry_id 00000003 has no eligible for education
it will also considered no number_of_no_school as 0..

is it possible?? thanks!

VFP9.0 via MySQL 5.0

khtan
In (Som, Ni, Yak)

Singapore
17681 Posts

Posted - 11/16/2013 :  23:11:31  Show Profile  Reply with Quote
this thread is a continue from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=189693


KH
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000