RDS Does Not Support Complex Joins

An SQL query passed to an RDS control may contain a single Join predicate, but not two Joins or more. These queries also must not contain Like clauses. These limitations are due to RDS's reliance on the client-side cursor library for data manipulation. Some advanced queries are not supported by client-side cursors.

For example, RDS will silently fail to execute the following SQL queries:

SELECT * FROM Title AS t JOIN TitleAuth AS ta ON t.bib#=ta.bib# JOIN Author AS a ON ta.auth#=a.auth# WHERE bib#=<%= nBibNo %>

SELECT * FROM Title AS t WHERE t.call LIKE '%<%= strCall %>%'