On Mar 10, 2006, at 0:55 , Larry White wrote:

Is there some way to wrap these two independent queries in a "CREATE VIEW myview AS" statement?

CREATE VIEW myview AS
Select name, description, date from Tasks
UNION
Select name, description, date from Issues;

Michael Glaesemann
grzm myrealbox com




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to