Hello,
I've looked at several examples for the "In" operator but they all use a static List instead of a subquery. Can someone please tell me what the Query Spec equivalent of the SQL below would be?
select top 300 v.*
from view_BaseProfile v
where v.UserName
Not In (Select UserName From ProfileUpdateAudit)
Or v.LAST_UPDATED >
(select a.LastUpdateDate
from ProfileUpdateAudit a
where a.UserName = v.UserName)