> 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
[EMAIL PROTECTED]
MAEM: Subject: not in -- not exists
MAEM:
MAEM: Dear all can anyone help me to use NOT IN
MAEM:
MAEM: or NOT EXISTS command in mysql ..
MAEM:
MAEM: Thsnks
MAEM:
MAEM:
MAEM: Name : Mohamed Abd El-Samei Mohamed
MAEM: Title : System Adminis
Dear all can anyone help me to use NOT IN
or NOT EXISTS command in mysql ..
Thsnks
Name : Mohamed Abd El-Samei Mohamed
Title : System Administrator
Comp. : Soficom Communications S.A.E
Tele. : 737-1952/3
Fax : 7547415
E-mail: [EMAIL PROTECTED]
---
