-- 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

##</code><code>##

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