SQL Learning Center - GoldMine

Use SQL queries to get answers from GoldMine

November 1, 2005

Primary Email Address

by Doug Steinschneider @ 5:41 pm. Filed under Details 
SELECT
 c1.contact
,concat(cs.contsupref,cs.address1) AS EmailAddress
,c1.accountno
FROM
 contact1 c1
JOIN contsupp cs
 ON c1.accountno=cs.accountno
WHERE
 cs.rectype = 'P'
 AND cs.contact = 'E-mail Address'
 AND cs.zip LIKE '_1__'

GoldMine SQL Tutorial:

General SQL Tutorials:

SQL Help Links:

Recommended Reading - SQL Books:

RSS:

Links:

Search For SQL Query:

GoldMine MS SQL Queries:

GoldMine dBase SQL Queries (LocalSQL):

21 queries. 0.060 seconds