How to select top 1 from table1 where table2 contains a list of values to select on

Table 1 = list of client transactions (many per client)
Table 2 = list of client numbers to use as selection critera (1 each)
Table 3 = client table containing the status of client; i only want clients with a status of 'AC'

I only want the most recent transaction based on a transaction date (top 1 ?)

I could eliminate table 3 references by performing that step in the reporting process.

I've spent hours trying to figure this crazy thing out.
Help would be glorious
thanks,
John

re: How to select top 1 from table1 where table2 contains a list of values to select on

Could you post some sample data?

-- CK