i solved the problem...
for the ones, who wants to know:
only creating an index on artikelnummer on both tables made the query
beeing ready after 2 seconds again :-)
Oliver
On Wed, 15 Sep 2004 00:38:59 +0200, Oliver Schiessl
<[EMAIL PROTECTED]> wrote:
MySQL 3.23.58:
ive got 2 tables w
MySQL 3.23.58:
ive got 2 tables with ca. 3 entrys each
now i wanna join, if one entry is in the one table, which isnt in the
other one
so this will be a normal join:
Tabelle1:
Artikelnummer, blah, blah, blah
Tabelle2:
Artikelnummer, blah, blah, blah
select Tabelle1.Artikelnummer from Tabelle
pray, that you use mysql version >=4
in version 3 it doesnt work...
Oliver
On Tue, 14 Sep 2004 14:09:43 -0400, <[EMAIL PROTECTED]> wrote:
Rhino, I hate to burst your bubble but JOINS __are allowed__ in MySQL
updates. I use them all the time.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
At the top
