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
to:
06/10/2004 01:35 Subject: mysql 3, subquerie
alternative
PM
You might do something like:
SELECT t1.* FROM t1 LEFT JOIN t2 ON(t1.field1=t2.field1 AND field2={fieldvalue}) WHERE
{all kinds of limits} AND t2.field1 IS NULL LIMIT 0,20;
the LEFT JOIN/WHERE idfield IS NULL will join the table and then lists
rows in table 1 that don't exist in table 2
Mark van
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
On Thursday, June 10, 2004, 1:20:03 PM, Mark wrote:
MvB Hi,
MvB For a project I'm creating a search function, the deal is this, a select
MvB query must be submitted and in this query a check must be done to confirm a
MvB previously found and accepted item is not shown anymore, a short version of