Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This request identify all records in TABLE2 which are not in TABLE1 (depending on
value of FIELD).
TABLE1 and TABLE2 have exactly the
alexandre Roussel wrote:
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This request identify all records in TABLE2 which are not in TABLE1 (depending on
value of FIELD).
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel
[EMAIL PROTECTED] wrote:
subselects are not currently supported with MySQL.
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This