SELECT ValueNames.ValueID, ValueNames.Value, ValueClass.ValueClassID, ValueClass.ValueClass FROM ValueNames LEFT JOIN ValueClass ON ValueClass.ValueClassID = ValueNames.ValueClassID ORDER BY ValueClass, Value ASC SELECT DISTINCT CaseValues.ValueID, CaseValues.Value, ValueClass.ValueClassID, ValueClass.ValueClass FROM CaseValues LEFT JOIN ValueClass ON ValueClass.ValueClassID = CaseValues.ValueClassID WHERE CaseValues.ValueID NOT IN (SELECT CaseValues.ValueID FROM CaseValues LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID WHERE Cases.CaseNum = "#ValueAdd.CaseNum#" WHERE Cases.CaseNum = "#URL.CaseNum#" ) ORDER BY Value, ValueClass ASC SELECT * FROM ValueClass ORDER BY ValueClass ASC SELECT ValueID FROM CaseValues ORDER BY ValueID DESC SELECT ValueNames.ValueID, ValueNames.Value, ValueClass.ValueClassID, ValueClass.ValueClass FROM ValueNames LEFT JOIN ValueClass ON ValueClass.ValueClassID = ValueNames.ValueClassID WHERE ValueNames.ValueID = #URL.ValueID# SELECT Cases.CaseID, Cases.CaseNum, Cases.Citation, CaseValues.CaseValueID, Cases.Hyperlink, CaseValues.ValueID, CaseValues.Value, CaseValues.ValueClassID, ValueClass.ValueClass FROM CaseValues LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN ValueClass ON ValueClass.ValueClassID = CaseValues.ValueClassID WHERE CaseValues.CaseValueID = #URL.CaseValueID# SELECT CaseID, CaseNum, Citation, Hyperlink FROM social.Cases WHERE Cases.CaseNum = "#URL.CaseNum#" ORDER BY CaseNum ASC SELECT CaseValues.CaseID, CaseNum, Citation, Hyperlink, CaseValues.CaseValueID FROM social.CaseValues LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID WHERE CaseValues.CaseValueID = "#URL.CaseValueID#" ORDER BY CaseNum ASC