SQL Learning Center - GoldMine

Description:This query is for a dBase hosted GoldMine. It returns the field names organized by field screen.

SELECT
 f52.label AS ScreenView
,f51.label AS ScreenName
,f51.fldname AS Fieldname
,f51.fldpos
FROM fields5 f51
 JOIN fields5 f52
  ON f51.viewid = f52.viewid
WHERE
 SUBSTRING(fldname FROM 1 FOR 1) = 'U'
 AND f52.fcol IS NULL
 AND f52.label = 'Tech Support Screen'
GROUP BY
 f52.label
,f51.label
,f51.fldname
,f51.fldpos
ORDER BY
 f51.fldpos