Oct 12, 2010 #1 phil3000 IS-IT--Management Joined Jul 7, 2009 Messages 27 Location 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 Joined Dec 24, 2008 Messages 287 Location 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