The ''having marked=-1' clause filters out records after the entire query is
completed. The where clause modifies which recorded get included in the
first place.
> for now it's rather ugly and inefficient, but one way you could do it
would
> be like this:
>
> select table1.*, ifnull(table2.colu
arl Karsten" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, March 16, 2001 12:13 AM
> Subject: Re: question about NOT IN
>
>
> > select * from table1 where column1 not in (select column2 from table2)
> >
&g
done something similar before, and it worked ok. Of course having
subqueries will be nice.
- Original Message -
From: "Carl Karsten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 12:13 AM
Subject: Re: question
select * from table1 where column1 not in (select column2 from table2)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 7:13 PM
Subject: question about NOT IN
> Please I would want how I can get the list of records from a
> table1 tha
