>>>Now if they would just do the same with CREATE QUERY.
>>>
>>
>>Well you have almost the same thing:
>>
>>CREATE VIEW
>
>Have you tried it? According to the docs CREATE VIEW is not available in a distributed EXE.
Sorry, I don't use views at all so I put the wrong syntax, I should have said:
CREATE SQL VIEW < myView > ;
AS < Select statement >