ProductColumn

[albCode]

How can I get product of two columns. example Column1 * Column2 = Result I used this to be more clearly...

[oykica]

You need to give the column an alias. e.g. SELECT 1 * 2 AS total FROM tablename

[Colin Angus Mackay]

oykica wrote: You need to give the column an alias Actually, you don't need to give the column as an alias. It can remain without a name.

---

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[Colin Angus Mackay]

To get the product of two columns you can perform a statement like this:

SELECT Column1 * Column2 AS Result FROM TableName

The AS Result is optional, it just names the column "Result" and can be omitted.

---

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[oykica]

Colin is correct. You don't have to provide an alias in order to get the product of the two columns. I assumed that you were trying to name your column because of the = Result in your example. If that is not what you were trying to do I hope I didn't confuse you. :)

[oykica]

I know. I assumed he wanted to name his column because of the = Result in his example and was trying to indicate that he could achieve this by using an alias. Perhaps I read more into the example than was required. :) I think it is good practice to name your calculated columns as it makes your commands easier to read and understand.