>> From: Will Leshner <[EMAIL PROTECTED]> >> Date: Sun, 24 Oct 2004 15:12:37 -0700 >> To: [EMAIL PROTECTED] >> Subject: 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 >>
Or leave the table-name qualifications off the projected columns: select column1, column2 ... Regards