sorry to bother you but...

[nekobaka]

I have to write a paper and I don't quite get it.
I have to explain:

SELECT namelist name, computergrade1+computergrade2
FROM namelist gradelist
WHERE studentnumber=gradelist studentnumber
AND subject LIKE 'computer%'

my question is, with SELECT why it there namelist (space) name.
I assume that there are two tables called name list and grade list. Isn't it enough to have that with FROM? I can't find any examples of two words with a space between them, I thought you always need a comma. Same with the WHERE line, isn't it strange to have a space after gradelist? the AND and LIKE part are ok I think. the desired result would be the:

name student number computergrade total

I will understand if no one wants to answer or has no idea what I'm taking about, but I would really apprechiate anyone who could help me.

[Mark Gambo]

It looks likeyou forgot toadd periods after the Table names. Try this:

SELECT namelist.name, gradelist.computergrade1 + gradelist.computergrade2
FROM namelist, gradelist
WHERE namelist.studentnumber = gradelist.studentnumber
AND gradelist.subject LIKE('computer%')

[nekobaka]

SELECT namelist.name, gradelist.computergrade1 + gradelist.computergrade2

Thank you so much for your reply. So I was correct in assuming that it's strange to have a space between namelist and name? This is how it was printed on the report question, so I was confused.