User location table?
I need the location field which contains the name. the user contains the location_iD but not the name itself. Ive been looking all over the schema and cant find it. Desperately need it for a query. Anyone?
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
KevinG
2 years ago
Locations are an Asset with an asset_type_id == 1
So the Name column would contain the location name.
The following SQL will display the name for each matching row in the table ASSET in the database named ORG1.
select name from ORG1.ASSET where asset_type_id = 1
