--Show all project ids and funds for all active projects
SELECT 
GL7PROJECTS.[PROJECTID] "Project ID",
GL7PROJECTS.[DESCRIPTION] "Project description",
T_4.[FUNDID] "Fund",
T_4.DESCRIPTION "Fund description"

FROM 
DBO.GL7PROJECTS
LEFT OUTER JOIN DBO.GL7TRANSACTIONDISTRIBUTIONS AS T_1 ON GL7PROJECTS.GL7PROJECTSID = T_1.GL7PROJECTSID 
LEFT OUTER JOIN DBO.GL7TRANSACTIONS AS T_2 ON T_1.GL7TRANSACTIONSID = T_2.GL7TRANSACTIONSID 
LEFT OUTER JOIN DBO.GL7ACCOUNTS AS T_3 ON T_2.GL7ACCOUNTSID = T_3.GL7ACCOUNTSID
LEFT OUTER JOIN DBO.GL7FUNDS as T_4 ON T_3.GL7FUNDSID = T_4.GL7FUNDSID 

WHERE 
((GL7PROJECTS.[ACTIVEFLAG]  =  1) AND GL7PROJECTS.[GL7GENERALINFOID]  =  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.