The following features are supported for the SELECT statement:
1. Using * to select all columns is supported.
SELECT * FROM Lead2. Column aliases are supported.
SELECT FullName AS MY_FullName FROM Lead3. Quoted column names are supported.
SELECT [FullName] FROM Lead4. The =, <>, >, <, >=, <= are supported in the WHERE Clause.
SELECT * FROM Lead WHERE FirstName <> 'John Smith';5. ORDER BY and LIMIT are supported
SELECT * FROM Lead ORDER BY FirstName LIMIT 106. Parameterized SELECT statements are supported.
SELECT * FROM Lead WHERE FirstName = @param
The RSSBus JDBC Driver for MSCRM offers some input-only fields in the SELECT Statements. These fields, called pseudo-columns, do not
appear as regular columns in the results, yet may be specified as part of the WHERE clause. Pseudo-columns allow
access to additional features from MSCRM.
SELECT * FROM Lead WHERE ODataFilter = startswith(FullName, 'C')
The SQL Syntax for the SELECT statement has the following limitations in this version (when compared to tools like SQL Server):
- Table joins are not supported, so a query can only reference a single table in the FROM clause.
- GROUP BY, HAVING clauses and nested statements are not supported.
- Scalar or aggregation functions are not supported.