Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sikharma13
Starting Member
44 Posts |
 Posted - 2013-11-16 : 19:12:32
|
| i have table payroll and has column number of eligible for educationentry_id===no_eli_educ00000001========2=====00000002========3=====00000003========0=====and i havecolumn name_of_schools in table schoolsentry_id===name_of_schools00000001===adamson high00000002===lasalle high00000002===no facility00000002===guanlun high00000003===no facilityi want to add a column number of no school in my payroll tablewherein this is my expected outputnumber_of_no_school00000001===000000002===100000003===0since entry_id 00000003 has no eligible for educationit 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)
17689 Posts |
|
|
|
|
|
Help! :)