By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Sep 19 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Could you post some sample data?

-- CK
Sep 21 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.