Another Solution:

SELECT [f1], [f2],temp1.detail1,temp2.detail2 FROM [a]

left outer join (select [id] id1 ,detail detail1 from b) temp1 on temp1.id1=f1

left outer join (select [id] id2,detail detail2 from b) temp2 on temp2.id2=f2

I don't think you can do it through the NewMail object. Assuming you are using CDONTS with IIS server: you can setup the default smtp server with Internet Information...

Are you co-locating your own server with sql installed, or is the hosting company providing you with sql server access? If the sql server access is provided by the...

I agree with Andy that this is probably a connection pooling issue. I would also recommend running these queries in Query Analyzer and see if the results are correct....