Using Reports → Report Search Criteria → Using Advanced SQL Conditions in SBM Reports → About Pass-Through SQL → Examples of Using Joins in Pass-Through SQL
Example of using a join with TS_STATES (the "State" is automatically selected for primary item reports) for the purpose of seeing any items sitting in states that are deleted:
@TS_STATES where TS_STATE = TS_STATES.TS_ID and TS_STATES.TS_STATUS =1
Example of finding all of the companies who own Platinum (150) service agreements (select the Companies table from the Report Item Type drop-down list on the report form):
@TTS_SERVICEAGREEMENTS where TS_COMPANIES.TS_SERVICEAGREEMENT = TTS_SERVICEAGREEMENTS.TS_ID and TTS_SERVICEAGREEMENTS.TS_SERVICE_AGREEMENT_TYPE = 150
Copyright © 2001–2016 Serena Software, Inc. All rights reserved.