Useful queries

To select multiple values

 select LOCATIONID, * from LOGISTICSLOCATION where DESCRIPTION IN('Active 4', 'test12')

select LOCATIONID, * from LOGISTICSLOCATION where DESCRIPTION = 'Active 4' OR DESCRIPTION = 'test12'

Exists Join

select * from INVENTTRANS where exists ( SELECT * FROM INVENTTRANSORIGIN where INVENTTRANSORIGIN.RECID = INVENTTRANs.INVENTTRANSORIGIN AND inventTransOrigin.InventTransId = '6135-000654')

select * from CustTable where exists ( SELECT * FROM DirPartyTable where DirPartyTable.RECID = CustTable.PARTY AND DirPartyTable.PRIMARYADDRESSLOCATION = 68719597356)