How to limit rows read to 1 rows

["Darryl Freinkel" <dfreinkel@xxxxxxxxxxxxxxxxx>]

I have a SELECT statement that returns more than 1 record for a invoice. The
file can have 1 to many invoice records with the same invoice number.

 

I need a way to limit the select, to read only one of those invoice records.

 

There is a solution using LIMIT, but I cannot get that to work.

 

Example:

 

Select * from table1 T1 where T1.INVOICE in

(Select T2.Invoice from table2 T2 where T1.Invoice = T2.invoice LIMIT 1)

 

TIA

 

Darryl Freinkel