Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT LOCSTATE.LOCGEOSTATE
, LOCSTATE.LOCNAMESTATE
, LOCSTATE.LOCABBREVSTATE
, LOCCOUNTY.LOCGEOCOUNTY
, LOCCOUNTY.LOCNAMECOUNTY
, LOCCOUNTY.LOCABBREVCOUNTY
, LOCCITY.LOCGEOCITY
, LOCCITY.LOCCOMPRESSEDCITY
, LOCCITY.LOCNAMECITY
, LOCCITY.LOCABBREVCITY
, LOCCITY.LOCZIPCODESTART
, LOCCITY.LOCZIPCODEEND
, LOCCITY.LOCAPOFPOIND
, LOCCITY.LOCCITYNAMETYPE
FROM LOCSTATE
, LOCCOUNTY
, LOCCITY
WHERE (LOCSTATE.LOCGEOSTATE = LOCCOUNTY.LOCGEOSTATE)
AND (LOCCOUNTY.LOCGEOSTATE = LOCCITY.LOCGEOSTATE)
AND (LOCCOUNTY.LOCGEOCOUNTY = LOCCITY.LOCGEOCOUNTY)