[ale] Selecting from multiple tables

George Carless kafka at antichri.st
Mon Oct 3 10:19:20 EDT 2005


On Mon, Oct 03, 2005 at 09:21:37AM -0400, Grant Robertson wrote:
> True, but as he said already, this isn't a join. This is more, uh,
> concatenation. I don't think it's possible at least not within the
> result set itself. To truly do what Christopher needs to do here, the

Sorry, I didn't read as well as I should have.  But I think that as Mike 
indicated, a cross-database UNION query should do the trick.  Your point 
about the schema is a valid one, though...

(Yes, you can do select into, btw.)

--George



More information about the Ale mailing list