Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL and Pending activites

Status
Not open for further replies.

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
 
select AccountNo,
Contact
from Contact1
where AccountNo not in
(select distinct AccountNo
from Cal)
order by Contact

DJ Hunt
Phone: (978)2-3333
WebSite:
- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top