Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM PublicRequest
- WHERE RequestType IN ('Free', 'Billable', 'Referral', 'Embed')
- AND ProspectID NOT IN
- (SELECT ProspectID FROM Leads WHERE LeadSource <> 'Agent' AND LeadAgentStatus <> 'is_an_agent')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement