I'm trying to add up 2 columns that are in 2 different tables:
points in `hof` and score in `mission_scores`
Is there a way to do this with one query or do i need to run 2 different queries and add them together?
Point Adding
Moderator: General Moderators
-
sk8erh4x0r
- Forum Commoner
- Posts: 43
- Joined: Wed May 26, 2004 8:27 pm
?
...or if using something to identify what rows to add...
Code: Select all
select
(hof.points + mission_scores.score) as named
from
hof, mission_scoresCode: Select all
select
(hof.points + mission_scores.score) as named
from
hof
inner join mission_scores on mission_scores.id = hof.id