Hi,
For a project I'm creating a search function, the deal is this, a select
query must be submitted and in this query a check must be done to confirm a
previously found and accepted item is not shown anymore, a short version of
the query I need is this:
SELECT * FROM t1 WHERE {all kinds of limits} AND 0 = (SELECT count(*) FROM
t2 WHERE field1=t1.field1 AND field2={fieldvalue}) LIMIT 0,20;
I don't know if the above query gives the result I want for starters, but if
someone gets the idea and know a way to implement a query like this in mysql
3 instead of mysql 4.1+ I'd like to know. I cannot just upgrade to mysql
4.1+ since the database is on a rented server and I'm just the geek trying
to fix some things on the site.
Greetings Mark
