Thanks to all! The AS keyword did the trick.
Philippe Poelvoorde wrote:
SELECT mem_number, first_name, last_name, joining_points + emc +
sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw +
saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo +
csf + coc + ncmc
Jacques
Thank you, I will give it a try.
Jacques Marneweck wrote:
Schalk Neethling wrote:
Greetings
Please have a look at the following code and let me know if this is
the correct way to create a virtual row. Also, after having run this
MySQL returns the error that the row total_points, d
SELECT mem_number, first_name, last_name, joining_points + emc + sapmc +
starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty +
safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc +
ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points
ncmc + gmgp + nlm
