From/Where Clause Syntax Examples - From/Where Clause Syntax Examples - OnBase - Database Reporting Guide - OnBase/Database-Reporting-Guide/Foundation-24.1/Database-Reporting-Guide/Appendices/Writing-Customized-Custom-Queries-Within-OnBase/From/Where-Clause-Syntax-Examples - Foundation 24.1 - Foundation 24.1

From Clause

hsi.itemdata, hsi.keyxitem113, hsi.keytable113

Where Clause

hsi.itemdata.itemnum= ki.itemnum 
and hsi.keyxitem113.keywordnum= hsi.keytable113.keywordnum
and substring(hsi.keytable113.keyvaluechar,1,1)= 'A’ 
and hsi.itemdata.itemtypenum = 101 and hsi.itemdata.status + 0 = 0