[big dream]

hello everyone ,, I have problem when I run this command

select C.coursename, T.teacherid, T.teachername from teacher as T, course as C
group by C.coursename, T.teacherid, T.teachername;

error is appearing which is:
"SQL command not properly ended"


Could u please tell me what's a problem in it!!

[baavgai]

The "as" will probably throw it. Some databases do ";" at the end, some don't:

select C.coursename, T.teacherid, T.teachername 
	from teacher T, course C
	group by C.coursename, T.teacherid, T.teachername

However, the problem now is you can see there is no "where" clause. A new SQL engine might choke on that. The comma thing really isn't standard. Using join syntax will high light what you need to do:

SELECT c.coursename, t.teacherid, t.teachername 
	FROM teacher t
		INNER JOIN course c
			ON ???
	GROUP BY c.coursename, t.teacherid, t.teachername

Also, the group by makes no real sense. Perhaps:

SELECT c.coursename, t.teachername 
	FROM teacher t
		INNER JOIN course c
			ON t.teacherid=c.teacherid, 
	ORDER BY c.coursename

Hope this helps.

[big dream]

Thanks a lot Baavgai..you were right