Thanks, I get it.
2006/4/28, Frank Schönheit - Sun Microsystems Germany
<[EMAIL PROTECTED]>:
Hi Li Pan,
> But it seems
> to me that if I want to execute arbitrary SQL which has "query1" in
> its FROM, I will still get trouble.
Yes. If you have a complete, complex SQL statement based on a query,
this won't work. If you have the query name, and the parts which should
constitute the SQL statement (query name, filter, sorting, group by
clause, having clause), then the query composer would be of help.
> If there is "query on query", can I do this?
Yes.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
