Quick Q as I cant find much in books / google. If I wanted to add two columns together how would I do that in SQL?
1 plus 1 = 2
Where 1 is is column 1, the other 1 is column 2 and the answer is in the "total" column.
If it is possible what would the syntax look like?