SQL help

[Ruslan Zasukhin]

On 1/1/14, 10:28 PM, "Jay Madren" <jay at jaymadren.com> wrote:

> Something like this should work:
> 
> SELECT voyageID FROM voyages WHERE RecID = (SELECT RecID - 1 FROM voyages
> WHERE voyageID = 'S1301')

RecID - 1       is very danger.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]