Syntax errors. Try: SELECT studenti.* FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE ISNULL( valutazioni.sid )
Ignatius ____________________________________________ ----- Original Message ----- From: "Francesco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 4:55 PM Subject: mysql problem > Hello, > I tried to execute the following query: > SELECT studenti.* > FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid > WHERE valutazioni.sid IS NULL; > and give me the following error message: > ERROR 1066: Not unique table/alias: 'valutazioni' > I have the Mysql 4.0.1 alpha version. > I want to know what is the problem. > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
