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