SELECT <published_columns> FROM [dbo].[ardly] WHERE ardly.dlysourcesalesman
IN (select slsmanno from filter2 where subscriber = HOST_NAME())

can I do something like this?

This works for the first sync, but change the values in filter2 cause no
effect, I'd like to look up multiple salespeople per HOST_NAME--


I can achieve this in a joined filter, but its too much data, inserts into
filter2 take awhile, and any over lapping data is resent to other
subscribers when I chg the values in filter2