Hi Jay, Friday, July 21, 2006, 7:05:59 PM, you wrote:
JS> Can you change the alias to a different field name than the source tables? I try: select t1.field1 as otherfield1, t2.field2 as otherfield2 from table1 t1 left join table2 t2 on (t1.id=t2.refid) and I receive the message on a mistake "no such column: t1.field1(1)" JS> On 7/20/06, blins <[EMAIL PROTECTED]> wrote: >> Hi sqlite-users@sqlite.org, >> >> I use sqliteODBC 0.68 + ADO and SQLite 3.3.6. >> I try executing sql: >> select t1.field1 as field1, t2.field2 as field2 from table1 t1 left join >> table2 t2 on >> (t1.id=t2.refid) >> >> and I receive the message on a mistake "no such column: t1.field1(1)" -- ????????? "????? ????? ??????? ?? ?????" Ñ íàèëó÷øèìè ïîæåëàíèÿìè, blins mailto:[EMAIL PROTECTED]