The easiest method to pull a list of phone numbers/emails/website links etc would be to use the QCONSTITPHONES2 view. You can then link the results of that view to the RECORDS table to get the constituent information and filter by specific phone types as needed. A join to the TABLEENTERIES table would be needed to filter by phone types. Here is a SQL sample which illustrates how to list the phone types with the corresponding TABLEENTRIESID.
 
select DISTINCT TE.TABLEENTRIESID, TE.LONGDESCRIPTION, TE.PHONETYPE from QCONSTITPHONES2 QC
inner join TABLEENTRIES TE on QC.PHONETYPEID = TE.TABLEENTRIESID



The following is a SQL query example (using the RE sample database) of the table joins that would be needed for all three tables with a filter for Phone Type not equal to Email. 
 
SELECT 

 RECORDS.FIRST_NAME "First Name",
 RECORDS.LAST_NAME "Last Name",
 T_1.LONGDESCRIPTION "Phone Type_1",
 RECORDS_QCONSTITPHONES2.NUM "Phone Number",
 RECORDS.ID "QRECID"

FROM 

DBO.RECORDS AS RECORDS 
LEFT OUTER JOIN DBO.QCONSTITPHONES2 AS RECORDS_QCONSTITPHONES2 ON RECORDS.ID = RECORDS_QCONSTITPHONES2.CONSTIT_ID 
LEFT OUTER JOIN DBO.TABLEENTRIES AS T_1 ON RECORDS_QCONSTITPHONES2.PHONETYPEID = T_1.TABLEENTRIESID

WHERE 

(( NOT EXISTS (SELECT T_1.LONGDESCRIPTION "Phone Type" FROM 
DBO.RECORDS AS X_RECORDS INNER JOIN DBO.QCONSTITPHONES2 AS RECORDS_QCONSTITPHONES2 ON X_RECORDS.ID = RECORDS_QCONSTITPHONES2.CONSTIT_ID INNER JOIN DBO.TABLEENTRIES AS T_1 ON RECORDS_QCONSTITPHONES2.PHONETYPEID = T_1.TABLEENTRIESID WHERE 
(X_RECORDS.ID  =  RECORDS.ID)   AND (T_1.TABLEENTRIESID IN (270)))) AND (RECORDS.IS_CONSTITUENT  =  -1))

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.