>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 <[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.
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
|
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]