Consulta con un select

[paladincubano]

Uso Sql server 2008.

Eso que posteas tiene logica y se ve muy bien. Pero ahora mismo no lo puedo probar hasta manana que llegue a la oficina.
mira, el comando en espeficico es este:

Código SQL [-]
SELECT Professionals.ProfessionalID, Professionals.Company, 
Professionals.Picture, Professionals.Description, 
Professionals.Phone, Professionals.City, Professionals.State, 
node_activeuser.active, node_activeuser.PrioritizedListings, 
Professionals.Zip 
FROM Professionals 
INNER JOIN b_categories ON Professionals.ProfessionalID = b_categories.b_id_profession 
INNER JOIN node_activeuser ON Professionals.ProfessionalID = node_activeuser.b_id_username 
WHERE (b_categories.idCategory = @category) AND (node_activeuser.active = 1) 
AND (node_activeuser.PrioritizedListings = 1) 
AND (Professionals.Company LIKE '%' + @Keyword + '%')

entonces eso que pones iria al final agregandole al and no?

AND Professionals.ZipCode in (SELECT ZipCode FROM Temporal)