On Wed, 20 Nov 2002, Francesco wrote: > 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;
Hi! I think you don't have to specify valutazioni in the FROM subclause (is it the correct term?). SELECT studenti.* FROM studenti LEFT JOIN valutazioni ... Iikka > 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. > > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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