SQL question

[Guest]

I have 2 columns that i need to subtract together then display that result in
my datagrid, how can i do this in my SQL statement?

ex:
I need:

Begining_Cars - Sold_Cars = Remaining_Cars

and display Remaining_Cars in my grid

 

[Ben Lucas]

select Beginning_Cars - Sold_Cars as Remaining_Cars
from TableName