Thanks Egor, but the table names in the example are already lower case and I pasted them in SQL window of the client.
Since yesterday I have test to type the script manually at the prompt in a DOS-window and then all worked well. Trying to do the same in the SQL-window of MySQL-Front all was OK until I typed the statement: select shop.article, dealer, shop.price from shop, tmp where shop.article=tmp.article and shop.price=tmp.price; Now I got an alert-box which tells me: Table 'mybase.tmp' does'nt exist. Finally, it was no problem to: drop table tmp; Seems that the problem depends on MySQL-Front. Best regards Alf --- Egor Egorov <[EMAIL PROTECTED]> skrev: > > If so, you should wrote table name in lower case > (tmp instead of TMP), > because in the manual table name in lower case. > > Look at: > > mysql> SELECT * FROM TMP; > ERROR 1146: Table 'database_name.TMP' doesn't exist > mysql> SELECT * FROM tmp; > +---------+-------+ > | article | price | > +---------+-------+ > | 0001 | 3.99 | > | 0002 | 10.99 | > | 0003 | 1.69 | > | 0004 | 19.95 | > +---------+-------+ > 4 rows in set (0.00 sec) > > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > --------------------------------------------------------------------- > 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 > ===== _____________________________________________________ Följ VM på nära håll på Yahoo!s officielle VM-sajt www.yahoo.se/vm2002 Håll dig ajour med nyheter och resultat, med vinnare och förlorare... --------------------------------------------------------------------- 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
