Select
  PUSER.POS_USERNAME       As TcUser,
  PIMANVOLUME.PVOLUME_NAME As UserDefVol,
  PIMANVOLUME.PWNT_PATH_NAME,
  PUSER_PATHS.PVAL_0
From
  PUSER
Left Join PIMANVOLUME
On
  PUSER.RVOLUMEU = PIMANVOLUME.PUID
Inner Join PUSER_PATHS
On
  PIMANVOLUME.PUID = PUSER_PATHS.PUID
Inner Join PUSERS
On
  PUSER_PATHS.PUID = PUSERS.PUID
And PUSERS.PSEQ    = PUSER_PATHS.PSEQ
And PUSER.PUID     = PUSERS.PVALU_0
Order By
  PUSER.POS_USERNAME