Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
<CFQUERY DATASOURCE="xx" NAME="DispState" cachedwithin="#createTimeSpan(0,0,0,-1)#"> SELECT distinct StateTbl.StateID, StateTbl.StateName FROM StateTbl LEFT JOIN CityTbl ON CityTbl.StateID = StateTbl.StateID LEFT JOIN ChurchTbl ON ChurchTbl.ChCityID = CityTbl.CityID WHERE ChurchTbl.ChurchName <> "null" and ChurchTbl.ChurchStatus = 1 and CityTbl.CityStatus = 1 and StateTbl.StateStatus = 1 </CFQUERY>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.