SQL to Access Data from a User Defined Table in DNN

SQL Query

SELECT R.UserDefinedRowId,
F.FieldTitle,
D.FieldValue
FROM dbo.UserDefinedRows R
LEFT OUTER JOIN dbo.UserDefinedData D on R.UserDefinedRowId = D.UserDefinedRowId
INNER JOIN dbo.UserDefinedFields F on D.UserDefinedFieldId = F.UserDefinedFieldId
WHERE R.ModuleId = @ModuleId
ORDER by R.UserDefinedRowID

DNN Function

UserDefinedTableController.GetDataSet(ModuleID)