Re: SV: Help... How Do I?

"Lars Sjöström" wrote:
>
> Harvey <harveyb_at_erols.com> skrev i
> diskussionsgruppsmeddelandet:391E151D.93FA2B9F_at_erols.com...
> > Hi All!
> > select count(*) from seat_assignment where s_add_on_cd != 'N/A';
> > insert into stats (logged_on, system_date) values ('<results of the
> > above count>', sysdate)
> >
> > Thanks in Advance!
> >
> > Harvey
> I think a
> INSERT INTO STATS (l_o,s_d) select count(*).sysdate from seat_assignment
> where s_add_on_cd != 'N/A';
>
> will do the job for you.
>
> Lars

Thanks Lars! Received on Sun May 14 2000 - 00:00:00 CEST