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 <[EMAIL PROTECTED]> 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.
-- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org H: 814.825.0847 M: 814-341-6233