2nd Record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Justin Drennan (justin_at_none.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 13:45:05 +0200

Afternoon,

I am doing an update statement, and need to update a field in Table 1, with
a field found in table2. The problem is, there is SOMETIMES more than one
record corresponding in the 2nd table. In this event, I need to select the
2nd record in this table.

What would be the best way to do this, remembering, its on a join....

thanks,
Justin