| Description |
We need 4 additional fields to come from your store 'ContractManagement.store.ContractDetailViewBuffered':
* intSubLocationId
* strSubLocationName
* intStorageLocationId
* strStorageLocationName
You can refer to the query I made below..
SELECT ItemLocation.intSubLocationId
, SubLocation.strSubLocationName
, ItemLocation.intStorageLocationId
, strStorageLocationName = StorageLocation.strName
FROM tblICItemLocation ItemLocation
LEFT JOIN tblSMCompanyLocationSubLocation SubLocation ON SubLocation.intCompanyLocationSubLocationId = ItemLocation.intSubLocationId
LEFT JOIN tblICStorageLocation StorageLocation ON StorageLocation.intStorageLocationId = ItemLocation.intStorageLocationId
|