On Wednesday 18 February 2004 11:23 am, Gerard Samuel wrote: > On Wednesday 18 February 2004 10:58 am, Ilia Alshanetsky wrote: > > Yes, this is the correct behavior, without the table 'prefix' if you have > > common column names in the result set the data would lost. > > True about common column names. But isn't that where aliases come in??? > E.g. select a.foo as foo1, b.foo as foo2........ >
Another question. Can this behaviour be turned off, reverting sqlite, making it more compatible to other databases such as mysql, pgsql, mssql, etc???? Thanks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
