Okay. That's a good idea. But in a VIEW things like SUM or COUNT do not work...

So any other possibility?

Thanks in advance!


Best wishes,

Marc



-----Ursprüngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Mittwoch, 13. August 2003 09:40
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Work with 2 SQLs or more


Marc,

> That's not what I want. The SQL where only a example (ok a very bad

example). What I want is I send 2 SQL to the Interbase Server. He should run
the first SQL and the second SQL should work with the results from the
first. Know what I mean?

>

Yes, I know what you mean - but that isn't possible unless you save
SQL1 to a view.

Something like:

CREATE VIEW SALES_VOL_30000 AS
select * from article where sales_volumn >= 30000

And then do:

select field1, field4 from SALES_VOL_3000 where field...


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/