> Dear all can anyone help me to use NOT IN
>
> or NOT EXISTS command in mysql ..
You need to use left join the table and look for an inexisting link
select * from table 1
left join table2 on table2.key1=table1.id
where whatever
and table2.id is null
-
> Dear all can anyone help me to use NOT IN
>
> or NOT EXISTS command in mysql ..
You need to use left join the table and look for an inexisting link
select * from table 1
left join table2 on table2.key1=table1.id
where whatever
and table2.id is null
-
* Mohamed Abd El-Samei Mohamed
> Dear all can anyone help me to use NOT IN
>
> or NOT EXISTS command in mysql ..
None of these are commands...
NOT IN was introduced in version 3.21.14a, it is a variant of the IN
comparison operator. From the manual:
`expr NOT IN (value,...)'
Same as `NO
CREATE TABLE IF NOT EXISTS table_name (
id NOT NULL AUTO_INCREMENT PRIMARY KEY,
value VARCHAR(30) );
Mohamed Abd El-Samei Mohamed wrote:
MAEM: Date: Thu, 13 Dec 2001 13:59:46 +0200
MAEM: From: Mohamed Abd El-Samei Mohamed <[EMAIL PROTECTED]>
MAEM: To: [EMAIL PROTEC
