SQL-89 joins (joins in the WHERE clause) in ElevateDB are not optimized. You should move any such joins into the FROM clause and use the SQL-92 and higher:

[INNER|[LEFT|RIGHT] OUTER] JOIN

syntax instead. ElevateDB optimizes the JOIN syntax in the FROM clause, so the queries should perform very quickly. Please see the Optimizer and SELECT topics for more information.