rk1980factor (5/5/2016)
Just to clarify little bit more:1) i want to display all the records
2) but I want create new column says School which has data from either district or area. So if Grade =0 than school column will have district's data, if the Grade is NOT 0 than school column will have Area data
3) Similary I want to crate new column Zone which has data from either city or zip. So if Grade=0 than zone will have City's data and if the Grade is NOT 0 than Zone will have Zip's data.
Remember the Condition is applied one time for e.g. Grade is 0 or not so need to check everything in one statement.
Clarify? You mean, change.
Here is your original desired output, containing no columns called School or Zone. Why did you post this when what you wanted was something different?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.