Shell Programming and Scripting

I am using the following script

Code:

#!/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

Result:
Results:
host1 server1
database1 5
host2 server2
database2 5
host3 server3
database3 5

wanted Results:
Requried Result
host1 server1 database1 5
host2 server2 database2 5
host3 server3 database3 5

Thanks in advance

Code:

awk '/host/{printf("%s ",$0);next}{print}' file