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!

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

Search results for query: *

  1. ZoeVent

    How Do I Export Email Addresses using an SQL Query

    Thank you for this but it's still not drawing in the email address and providing me the previous error message. I have found a previous code which brings in the email addresses: select contact1.accountno, contact1.createon, contact1.company, contact1.address2, contact1.address3, contact1.city...
  2. ZoeVent

    How Do I Export Email Addresses using an SQL Query

    thank you. I have run the query with the above code but i'm presented with the following Database Error: Line 1: Incorrect syntax near 'E-mail Address'. ??????
  3. ZoeVent

    How Do I Export Email Addresses using an SQL Query

    SELECT C1.* FROM GM_VENT_DOM.DBO.CONTACT1 C1 JOIN (SELECT DISTINCT ACCOUNTNO FROM GM_VENT_DOM.DBO.CONTSUPP WHERE (CONTSUPP.RECTYPE = 'P' AND CONTSUPP.CONTACT = 'E-mail Address')) CS ON CS.AccountNo = C1.AccountNo WHERE (C1.Key3 = 'SE' OR C1.Key2 = '7. Work Complete') ORDER BY C1.CONTACT this...
  4. ZoeVent

    How Do I Export Email Addresses using an SQL Query

    I am using Goldmine 7.0 Corporate Edition and need to export our database to include the email addresses. I understand I need to use an SQL Query but I can't seem to insert the correct condition. Please help thank you

Part and Inventory Search

Back
Top