Greg
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Laslo Orto
> Sent: Friday, June 05, 1998 12:40 PM
> To: emerald@iea-software.com
> Subject: Re: Some SQL help please?
>
>
> select * from masteraccounts where customerid not in (select customerid
> from invoices)
>
>
> At 12:08 PM 6/5/98 -0400, you wrote:
> >Well, I am beating my brains out on the floor now :)
> >Can anyone tell me/show me, or even give me a hint as to an SQL
> script that
> >will show me a list of MasterAccounts that have NO invoices in
> the Invoice
> >table?
> >
> >
> >Gregory E. Keys
> >System Administrator
> >LoclNet (A Division of ESC Inc.)
> >Electro-data Systems Company Inc.
> >Voice: (704)861-1251
> >Fax: (704)861-1870
> >E-Mail: greg@loclnet.com
> >
>
>
> Laslo Orto Computer Pages / Better.Net
> Systems Administrator 253 Sheppard Ave. West
> laslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2
> www.cpol.com / www.better.net Ph: +1 416 225 3030
> Fax: +1 416 225 6737
>