Thanks GSquared. I changed it into this:

SELECT temp.*, ISNULL(tsa.IPAddress, '') AS IP

FROM

(SELECT tblServers.*, tblCustomers.custNum

FROM tblServers, tblCustomers

WHERE (srvName LIKE '%'+@srvName+'%'...

I have another question now.

Now the left join returns NULL values for servers that don't appear in the tblServersAddresses. If I want to show an empty filed, instead of NULL,...

Thanks you all for the helpful replies.

I changed the query into this:

SELECT tt.*, tsa.IPAddress

FROM

(SELECT tblServers.*, tblCustomers.custNum

FROM tblServers, tblCustomers

WHERE (srvName...