Syntax fejl i MySQL kald.

hvilken MySQL version ?

MySQL 4.0.24

den understoetter ikke sub select

og WHERE EXISTS SELECT er en sub select

Mærkeligt, den står ellers i manualen: http://dev.mysql.com/doc/refman/4.1/en/exists-and-not-exists-subqueries.html

Hvad har jeg af andre muligheder i min MySQL version?

det der er 4.1 manualen og du koerer jo 4.0 ...

Det er også rigtigt. Jeg er lidt på bar bund nu, har du nogen forslag til hvordan jeg elers kunne sætte det op?

Start med at lave følgende select:
SELECT annonceid FROM specifikation_annonce WHERE specifikation_annonce.specid ='118' AND value = '68 hd'

Hiv alle de resulterende ID's ud i en streng, adskilt af komma. (Det lader til du bruger PHP, så du kan smide dem i et array og dernæst lave om til en streng med explode())

Kør dernæst denne delete:
DELETE FROM annonceliste WHERE sessionsid='$session' AND annonceid NOT IN ($idliste)

det er nok den nemmeste loesning

alternativet er at lave en DELETE med en JOIN

det boer ogsaa kunne lade sig goere

Lave en delete med en join? Kan du uddybe det? Jeg kan forestille mig at det performer bedre end pidgeot ellers udmærkede forslag?

ikke noedvendigvis men PHP koden er simplere

http://dev.mysql.com/doc/refman/4.1/en/delete.html

et stykke nede:

From MySQL 4.0, you can specify multiple tables in the DELETE statement to delete rows from one or more tables depending on a particular condition in multiple tables. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE.

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE. The table_references clause lists the tables involved in the join. Its syntax is described in Section 13.2.7.1, “JOIN Syntax”.

The first multiple-table DELETE syntax is supported starting from MySQL 4.0.0. The second is supported starting from MySQL 4.0.2.

For the first multiple-table syntax, only matching rows from the tables listed before the FROM clause are deleted. For the second multiple-table syntax, only matching rows from the tables listed in the FROM clause (before the USING clause) are deleted. The effect is that you can delete rows from many tables at the same time and have additional tables that are used only for searching:

DELETE t1, t2 FROM t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;

Or:

DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;

These statements use all three tables when searching for rows to delete, but delete matching rows only from tables t1 and t2.

The preceding examples show inner joins that use the comma operator, but multiple-table DELETE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.

Tak for hjælpen arne_v, du må meget gerne svare.

ok