Hey guys, I need a little help with a SQL problem.
I have two tables
the question asksCode:|----------------
--------------| | CAR |
| PERSON | | |
| | |*carid |
|*personid | |carcost |
|persfname | | carsell |
|perslname | | cartype |
|--------------- -----------------
list details of all sales showing the gross profit (selling price minus cost price.)
I know I need
Now what I'm not sure of is the minus part. I know how to do AVG, SUM, COUNT etc, but am not sure how to subtract the carsell from the carcost.Code:Select person.*, car.*
from person, car
I'm pretty sure it needs to be in the select statement. Just need a little reminder here.
thanks.
for some reason the | are all screwed up.