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