[thelist] simple SQL help please
Asif Suria
asifsuria at yahoo.com
Thu Feb 2 16:06:42 CST 2006
This might be what you are looking for.
select A.* from A where A.company not in (select
distinct B.company from B)
Asif
---------------------------------------------------------------
If the doors of perception were cleansed everything
would appear to man as it is, infinite. William
Blake.
Yes, I am blogging @
http://www.sinletter.com/ablog.aspx
--- Rob Smith <rob.smith at lexjet.com> wrote:
> Hi,
>
>
>
> List A contains all leads acquired from a recent
> trade show. List B
> contains our entire contact database. Find all
> entries in List A, not in
> List B, without returning all contents of List B.
>
>
>
> I don't want:
>
>
>
> Select A.Company
>
> FROM A, B
>
> Where a.company <> b.company
>
>
>
> It's probably something simple...
>
>
> Rob Smith
> LexJet
> rob.smith at lexjet.com
> http://www.lexjet.com
> (800)453-9538
> (941)330-1210 Int'l
> (941)330-1220 Fax
> 1680 Fruitville Road, 3rd Floor
> Sarasota, FL 34236
>
> Proud Sponsors of the Professional Digital Imaging
> Association (www.pdia.org)
>
>
> --
>
> * * Please support the community that supports you.
> * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip
> Harvester
> and archives of thelist go to:
> http://lists.evolt.org
> Workers of the Web, evolt !
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
More information about the thelist
mailing list