List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:June 22 2006 11:05pm
Subject:Re: Exclusion Query
View as plain text  
 >SELECT *
 >FROM Customers C
 >LEFT OUTER JOIN Orders O
 >ON C.CustomerID = O.CustomerID
 >WHERE OrderID IS NULL OR C.CustomerID IS NULL
 >ORDER BY OrderID

Correct except lose "OR c.customerID IS NULL", it makes no sense.

PB

-----

Daniel McQuay wrote:
> had a problem like this in class today and we solved it with a LEFT OUTER
> JOIN. we had to find customers who did not place an order or orders 
> with no
> customers. this was in MSSQL but it may be something to work off of.
>
> USE Northwind
> SELECT *
> FROM Customers C
> LEFT OUTER JOIN Orders O
> ON C.CustomerID = O.CustomerID
> WHERE OrderID IS NULL OR C.CustomerID IS NULL
> ORDER BY OrderID
>
> HTH,
>
> On 6/22/06, Jeremy Rottman <rottmanlist@stripped> wrote:
>>
>> I am working on an MLS Exclusion report.
>>
>> In on table1 I have all the information we collect for our files. 
>> Each day
>> I
>> download an update our mls table (table2).
>>
>> what I am trying to do is find all the records in table2 that are not in
>> table1.
>>
>> This is the query that I am using.
>>
>> select *
>>
>> from tbl_IDX_Coded_RES
>>
>> where
>> tbl_IDX_Coded_RES.StreetNumDisplay
>>
>> Not IN (select status.fld_house_number from status where 
>> (fld_file_number
>> like 'L0%') and (fld_archived = '0'))
>>
>> The problem is it is not returning the correct information.
>>
>>
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date: 6/21/2006
>   

Attachment: [text/html]
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date: 6/21/2006
Thread
Exclusion QueryJeremy Rottman22 Jun
  • Re: Exclusion QueryDaniel McQuay22 Jun
    • Re: Exclusion QueryPeter Brawley23 Jun
  • Re: Exclusion QueryKarl Larsen23 Jun