Synametrics Technologies

Is there a way to access the fields from a saved named query to join a table and get results?

example: select * from "named query" and left join "table from database?"

Thank you in advance

Jessica,

Unfortunately, the answer is no. The reason is that in a client/server environment the actual JOIN occurs on the back-end rather than the front-end application (WinSQL in this case).

When you run a Named Query, all WinSQL does is to modify the WHERE clause with the result of another query before the outer query is sent to the back-end.

oh ok.

Thank you very much.