You can translate the question and the replies:

using view in where clause

Can I access a view in a where clause as follows: where clause ========== in ( select id from view2 ) where view2 is a cached base view with query
21-10-2014 16:01:56 -0400

1 Answer

Yes, that syntax will work correctly. For example, having the view address cached: SELECT client.client_id AS client_id, client.client_name AS client_name, client.surname AS surname, client.client_type AS client_type, client.company_code AS company_code FROM client WHERE client_id in (SELECT client_id FROM address);
Denodo Team
21-10-2014 16:36:16 -0400
You must sign in to add an answer. If you do not have an account, you can register here