[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