FK reference PK in same table

Hello, I have two questions: 1. I have a table defined as follows * create table MATABLE ( ID INTEGER not null, FK INTEGERnot null, constraint PK_MATABLE prima

AVG function in order by clause

Thank you all for your replies. Everything works now!! Julien. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AVG function in order by clause

ES.DB_ESTABLISHMENT_ID HAVING AVG(DB_GRADE) > 2 ORDER BY AVG(GRADE) ** Now I am having a problem with the order by clause. How can I have the AVG function in the ORDER BY clause or how can I sort by average grade? Thanks in advance, Julien Mar

Use of AVG in where clause

Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(DB_GRADE) > 2 GROUP BY ES.DB_

Basic problem with character sets

Hello, I am trying to display the following letter "ñ" (n with ~) on a web page. Basically I would like for the correct letter to appear in the web page as well as on the mysql console as well as in the html source. How do I do that? Thanks in advance, Julien. -- MySQL General Mailing List For l

How to change to the unicode character set

Hello, I would like to use the unicode character set instead of the latin1. Can anyone tell me how to do that please? Thanks in advance, Julien.