Re: Some SQL help please?

Laslo Orto ( laslo@cpol.com )
Fri, 05 Jun 1998 12:39:51 -0400

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