#!/bin/ksh /usr/sybase/bin/isql -SXYZ -UABC -PXYZ -b <<EOF >temp select A.host,A.server,B.db,A.status from dbo.server as A,dbo.db as B where A.product in (XX,YY) and A.server=B.server go EOF