Owain Jones

// Server-Devices Pane
SELECT //whatever fields you want//
FROM system
WHERE system.new_description = @System

// Passwords Pane
SELECT //all your fields//
FROM filterednew_ITCPasswordSystem as PassSys (nolock)
LEFT JOIN
  filterednew_itcpasswordsystemaccountdetails as AccountPasswords (nolock)
  ON AccountPasswords.new_passwordlognumberidname = PassSys.new_passwordlognumber
WHERE PassSys.new_system IN (
  SELECT new_systemid
  FROM system
  WHERE new_description = @System
)