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. How can I How do I configure SQLite to only return the field (or column) names? __ Raymond Irving