>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
Jeremy Rottman 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
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.Customer
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 tb
Hi Daniel,
> Jigal, thank you very much. However, this does not resolve my issue.
>
> even when querying:
> SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
> art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
> AND sec.sectionID NOT IN (3)
What *
yntax.
You can find info on joins at:
http://dev.mysql.com/doc/mysql/en/join.html
Regards, Jigal.
- Original Message -
From: "Dan Duris" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 23, 2005 10:35 AM
Subject: mysql exclusion query with JOIN (request for help)
> Anyon
Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art
LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID
LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID
LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID
WHERE
IL PROTECTED]]
Sent: Friday, February 08, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Exclusion Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
IL PROTECTED]]
Sent: Friday, February 08, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Exclusion Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
IL PROTECTED]]
Sent: Friday, February 08, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Exclusion Query help
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude the records with
hase enter into the selection of record 2?
-Original Message-
From: John Rosendahl [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Exclusion Query help
I am trying to run a query I have a table Records
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude the records with
13 matches
Mail list logo
