Re: Flag missing data in new table
From: Peter Morris <no_sp_at_m.please>
Date: Wed, 20 Dec 2000 12:49:50 -0000
Message-ID: <91q9sh$8lu$1_at_lyonesse.netcom.net.uk>
Date: Wed, 20 Dec 2000 12:49:50 -0000
Message-ID: <91q9sh$8lu$1_at_lyonesse.netcom.net.uk>
"Sean" <sean_gallivan_at_my-deja.com> wrote in message
news:91l3ht$j79$1_at_nnrp1.deja.com...
> Hello all,
> I'd appreciate any ideas here.
> I have to load from one table into another via a query.
> However if there were data missing on either of two fields, from the
> first table, I would like this data not to be loaded. Instead I would
> like another table produced which listed all the records (and therefore
> fields) that could not be loaded.
> Cheers all.
> Sean
Am I missing something here? It seems pretty easy to do.
insert into table2
select * from table1
where field1 is null
or field2 is null ;
Received on Wed Dec 20 2000 - 13:49:50 CET