sorry to bother you but...
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.