On Fri, 23 May 2003 20:45:32 +0200, papapep <papapep(at)gmx(dot)net> wrote:
>INSERT INTO totaltrajectes ([...])
>SELECT [...]
>FROM captrajectes,detalltrajectes
>
>Also I have to mention that this sentence works with about 650.000 rows
>~ in the table "detalltrajectes" and
>35.000 in the "captrajectes" one.
>Does anybody know a more effective way to fill the new table?
Yes. Use a WHERE clause :-) Your join produces 650000 * 35000 rows.
This should work:
... FROM captrajectes AS c, detalltrajectes AS d
WHERE c.pkey = d.journey;
Servus
Manfred