Title: Message
|
SELECT *
FROM Subset
LEFT JOIN Master ON Master.Pk =
Subset.Pk
WHERE Master.PK IS NULL;
It might be a right join, I always get it
mixed up.
Rob Martin Software Engineer phone 03 377 0495 fax 03
377 0496 web www.chreos.com
----- Original Message -----
Sent: Friday, March 19, 2004 9:46
AM
Subject: [DUG] Programming in Delphi, but
have a SQL question
I am trying to implement a new report in
Delphi, but I am having problems with the query. I know this is not a straight
Delphi question, but I was hoping someone here could steer me in the right
direction.
I have two tables with transactions. One
table contains ALL transactions, the second table is a subset of the first
with only a specific set of transactions. The columns differ between the two
tables, but there is enough relational information for me to match all of the
subset transactions with the master transaction table.
In some odd
cases the subset transaction is inserted, but the corresponding entry is not
added to the master transaction table.
I need to write a query that
shows which transactions in the subset table do not appear in the master
table.
Can someone help me with
this?
Thanks,
Eric
Eric Tishler
Software Architect
Resolute Partners,
LLC
Phone: 203.271.1122
Fax: 203.271.1460
[EMAIL PROTECTED]
_______________________________________________
Delphi mailing
list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
|
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
