Error for INNER JOIN with GROUP BY and WHERE claus

Question

I've got these tables

student:

id  Name
-------------------
1   john
2   carlos
3   zoya
4   arab
5   amir

and,

email:

id      email   student_id
--------------------------
1   [e-mail]      1
2   [e-mail]      2
3   [e-mail]      2
4   [e-mail]      3
5   [e-mail]      4

I'm using this query and it's getting Using sql error on query line 4,

SELECT * FROM student 
INNER JOIN email 
ON student.id = email.student_id 
GROUP BY student.id
WHERE student.id = 2

I don't have much experience in SQL.

Answer 1

Firstly, GROUP BY always goes after the WHERE clause.
Secondly, if you are using the GROUP BY clause you should either use aggregate functions for the fields, that are not contained in it and still are present in the SELECT clause, or GROUP BY the whole pack of columns contained in the SELECT.