On Tue, 5 Oct 2004 00:27:45 +0530, Eldo Skaria wrote:
> I suppose these are the ways with Databases. They don't work the way
> we like them to.
> So please adjust with it. For this matter I think, any RDBMS will be
> doing their or paddings to the scripts when they are loading it in
But that doesn't make it right.
Specifically, I seem to remember from the SQL standard that the use of
database.table.field is undesired (or schema.table.field if you don't
use MySQL) and instead database.table should be aliassed. In that case
it should be:
CREATE VIEW test.myview2 AS select alias.c1 AS t0 from test.t alias;
Further, I would like to second Martijn's opinion regarding backticks.
It is bad enough that the SQL standard double quote isn't used, let's
not make it worse by including unwanted backticks.