On 9/11/07, Koen Bok <[EMAIL PROTECTED]> wrote: > Anyone has a hint?
Another way:
SELECT i.*
FROM item i JOIN search_item s1 ON i.ID = s1.id_item
JOIN search_item s2 ON s1.id_item = s2.id_item
JOIN search_item s3 ON s2.id_item = s3.id_item
WHERE s1.id_search = 1
AND s2.id_search = 2
AND s3.id_search = 3
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
