Title: Message
|
This should do it...
select * from Master MT
where not exists (select
ST.ID from Sub ST where ST.ID = MT.ID)
HTH
Regards
Paul McKenzie
Analyst Programmer
SMSS Ltd.
----- 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
