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

[Eric Tishler]

Title: Message

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