I have a local cursor ( search ). I have an external ODBC data source with a particular table that I would like to INNER JOIN with based on a projectID field in my local cursor.

Is it possible in an SQLPREPARE() to specify a JOIN condition with a local cursor or am I pushing this too far ? If it is possible, what might the syntax look like ?

Thanks