RE: [DUG] Programming in Delphi, but have a SQL question

[Chris Milham]

Title: Message

How about a sub-select eg.   Select * from sub_trans_table where trans_pk not in (select trans_pk from all_trans_table)   HTH   Chris -- Chris Milham BSc BD Senior Software Engineer EVP Holdings Ltd DDI: + 64 9 526 2423 Fax: + 64 9 571 0017 www.evp.cc The information contained in this e-mail (and any accompanying attachments) is confidential and may be legally privileged, intended only for the recipient named. Any use, dissemination, distribution or reproduction of this message by a recipient other the the addressee/s is prohibited.  If you have received this message in error, please delete the message and any attachments and notify the sender immediately. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Tishler Sent: Friday, 19 March 2004 9:46 a.m. To: NZ Borland Developers Group - Delphi List 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