Re: [sqlite] Preventing TableNames.columns inside SELECT

Thanks, I'll give it a try with version 3.0.8 __ Raymond Irving --- John LeSueur <[EMAIL PROTECTED]> wrote: > Raymond Irving wrote: > > >Hi All, > > > >Please consider the following example: > > > >I would like to only return the field names and not > >table.fieldnames... > > > >SELECT

Re: [sqlite] Preventing TableNames.columns inside SELECT

Raymond Irving wrote: Hi All, Please consider the following example: I would like to only return the field names and not table.fieldnames... SELECT t1.column1,t2.clumn2 FROM tableA t1,table2 t2 ..In MSSQL and others the recordset should only show column1, column2 but in SQLite it shows t1.column1

Re: [sqlite] Preventing TableNames.columns inside SELECT

On Oct 24, 2004, at 2:59 PM, Raymond Irving wrote: I would like to only return the field names and not table.fieldnames... SELECT t1.column1,t2.clumn2 FROM tableA t1,table2 t2 Can't you just use "as": SELECT t1.column1 as column1, t2.column2 as column2 FROM tableA t1, table2 t2

[sqlite] Preventing TableNames.columns inside SELECT

Hi All, Please consider the following example: I would like to only return the field names and not table.fieldnames... SELECT t1.column1,t2.clumn2 FROM tableA t1,table2 t2 ..In MSSQL and others the recordset should only show column1, column2 but in SQLite it shows t1.column1 and t2.column2.