SELECT MAX(ID) FROM TABLE1
union
SELECT MAX(ID) FROM TABLE2
union
SELECT MAX(ID) FROM TABLE3

Bogdan

-----Original Message-----

> At 01:12 PM 9/12/2003 +0000, you wrote:
> >In Oracle I'm used to using SQL to create SQL scripts. While I can
> >do the same in Firebird I can't seem to figure out how to run
> >multiple statements as a script.
> >
> >EXAMPLE
> >
> >SELECT MAX(ID) FROM TABLE1;
> >SELECT MAX(ID) FROM TABLE2;
> >SELECT MAX(ID) FROM TABLE3;
>
> This would be fine if they weren't SELECT statements. What is the
> objective of this erm...script...?
>
>

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/