Re: selecting rows with empty fields?

Thanks so much, John. I'm a learnin'!

"John L. Laine" wrote:

> You are 99% there already
> insert into TABLEA (COL_1, COL_2, COL_3)
> select COL_1, COL_2, COL_3
> from TABLEB where COL_3 IS NOT NULL;
>
> Fraser wrote:
>
> > I'm trying to insert data from one table to another, but I want the
> > insert statement to skip all rows where a specific field is empty.
> > For example:
> > insert into TABLEA (COL_1, COL_2, COL_3)
> > select COL1, COL_2, COL_3
> > from TABLEB where COL_3 = NOT NULL;
Received on Fri Jan 05 2001 - 17:01:25 CET