Oct 12, 2010 #1 phil3000 IS-IT--Management Jul 7, 2009 27 GB Is there any way of write an SQL statement that will search each company record and see if the pending activties are blank Any help is most gratful
Is there any way of write an SQL statement that will search each company record and see if the pending activties are blank Any help is most gratful
Oct 16, 2010 #2 DJHunt Technical User Dec 24, 2008 287 US select AccountNo, Contact from Contact1 where AccountNo not in (select distinct AccountNo from Cal) order by Contact DJ Hunt Phone: (978)2-3333 WebSite: http://www.DJHunt.US - The Hacker's Guide to GoldMine Premium - One-on-One GoldMine Technical Support ( Fee Based ) http://www.DJHunt.US/Default.html Upvote 0 Downvote
select AccountNo, Contact from Contact1 where AccountNo not in (select distinct AccountNo from Cal) order by Contact DJ Hunt Phone: (978)2-3333 WebSite: http://www.DJHunt.US - The Hacker's Guide to GoldMine Premium - One-on-One GoldMine Technical Support ( Fee Based ) http://www.DJHunt.US/Default.html