Need an sql
Table1    invoices
invoiceNum    ClientNum
1                        A
2                        A
3                        B
4                        C
5                        D

Table2   transactions

Client          TransDate
A                   01-01-2001
A                   02-01-2001  
C                   02-01-2001

Need this result all transactions with the InvoiceNumber No duplicate on InvoiceNumber
where the cliente are the same

InvNum             Client              Date
1                        A                   01-01-2001
2                        A                   01-01-2001
4                        C                   02-01-2001


Carlos

Carlos,

<< Need this result all transactions with the InvoiceNumber No duplicate on
InvoiceNumber where the cliente are the same >>

I think you've got a design issue here.  Shouldn't the invoice number be in
the transactions table, not the client number ?

--
Tim Young
Elevate Software
www.elevatesoft.com