-- Sybase syntax
create proc   get_address @addressee int
as     select street_address, city, state, zip
       from   addresses
       where  @addressee = addressee_id  -- addressee_id is the foreign key